Eager_For_Knowledge
New Member
- Joined
- Sep 2, 2014
- Messages
- 5
I'm trying to create the combination list of 2,3,4,5 or 6 numbers depending on what is required. For instance in cell(1,1) i put 6, in cell(1,2) i put 3, in cell(1,3) i put 4, then macro would produce the combination list of the 3 numbers listed and so on. i want the combination results to be listed in ColumnA, delimited like 1-12-24-5. if or when the combination results reach row 1048576, i want it to move to ColumnB when rows reach 1048576 move to ColumnC and so on, until the combination is complete. I'm new to VBA and need help.
Example:
ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG
2 Enter number here: 5 2 10 8 1
3 Results:
4 5-2-10-8-1
5 2-5-10-8-1
6 10-8-5-2-1
7
8
1048576 8-10-5-1-2
Example:
ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG
2 Enter number here: 5 2 10 8 1
3 Results:
4 5-2-10-8-1
5 2-5-10-8-1
6 10-8-5-2-1
7
8
1048576 8-10-5-1-2