creating combinations of values stored in arrays
Hi All,
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.
For ex:
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
a,b,c..
a,2,c..
a,3,c..
1,b,c..
1,2,c..
1,3,c..
How can I accomplish this? Please help. Thanks!
Re: creating combinations of values stored in arrays