November 20th, 2008 11:09 AM
creating combinations of values stored in arrays
This is more of a generic programming topi I guess, but I am trying to code up something in VB (newbie) for Excel.
In a row of Excel, I have multiple comma separated values stored in each column.
a,1 b,2,3 c ...
I have data in 10 such columns.
I have copied the comman seaparated values into individual arrays. i.e. one array per column.
I need to loop through all these and create combinations of these values.
My output should be
How can I accomplish this? Please help. Thanks!
November 20th, 2008 05:25 PM
Re: creating combinations of values stored in arrays
Click Here to Expand Forum to Full Width