title: Excel vba to create every possible combination of a Range
body: <p>I have a problem that I haven't been able to find anywhere on the web (it may be there, but I can't find it, heh).</p>
  
  <p>I have a spreadsheet with 13 columns of data.  Each of the column contains variations of a parameter that needs to go into an overall test case.</p>
  
  <p>All of them differ, like </p>
  
  <p>E:<br>
  101%<br>
  105%<br>
  110%<br>
  120%<br></p>
  
  <p>J:<br>
  Upper S<br>
  Upside L<br>
  Downside B<br>
  Premium V<br></p>
  
  <p>I have seen several solutions to the combination issue which uses nested loops.  I'd like to steer clear of 13 nested loops (but this is my best bet at the moment).  I'm kind of at a loss on how to generate every unique combination in in each column.</p>
  
  <p>I'm not sure if that makes enough sense for you guys. I was hoping someone could at least point me in the right direction with a recursive algorithm.  I'd like to make it dynamic enough to take varying numbers of columns and rows.</p>
  
  <p>Thanks for any help you guys can give me.</p>