-
November 20th, 2008, 12:09 PM
#1
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!
-
November 20th, 2008, 06:25 PM
#2
Re: creating combinations of values stored in arrays
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|