Excel VBA combinations for 2,3,4,5 or 6 numbers

[Eager_For_Knowledge]

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

 

[shg]

There's a workbook at https://app.box.com/shared/f3puhccnqa that will do this:

	B​	C​
7​	m​	1 2 5 8 10
8​	5​	10 8 5 2 1
9​	5​	10 8 5 1 2
10​	5​	10 8 2 5 1
11​	5​	10 8 2 1 5
12​	5​	10 8 1 5 2
13​	5​	10 8 1 2 5
14​	5​	10 5 8 2 1
15​	5​	10 5 8 1 2
16​	5​	10 5 2 8 1
17​	5​	10 5 2 1 8
18​	5​	10 5 1 8 2
19​	5​	10 5 1 2 8
20​	5​	10 2 8 5 1
21​	5​	10 2 8 1 5
22​	5​	10 2 5 8 1
23​	5​	10 2 5 1 8
24​	5​	10 2 1 8 5
25​	5​	10 2 1 5 8
26​	5​	10 1 8 5 2
27​	5​	10 1 8 2 5
28​	5​	10 1 5 8 2
29​	5​	…

It won't do more than one column.

 

[Eager_For_Knowledge]

There's a workbook at https://app.box.com/shared/f3puhccnqa that will do this:

	B​	C​
7​	m​	1 2 5 8 10
8​	5​	10 8 5 2 1
9​	5​	10 8 5 1 2
10​	5​	10 8 2 5 1
11​	5​	10 8 2 1 5
12​	5​	10 8 1 5 2
13​	5​	10 8 1 2 5
14​	5​	10 5 8 2 1
15​	5​	10 5 8 1 2
16​	5​	10 5 2 8 1
17​	5​	10 5 2 1 8
18​	5​	10 5 1 8 2
19​	5​	10 5 1 2 8
20​	5​	10 2 8 5 1
21​	5​	10 2 8 1 5
22​	5​	10 2 5 8 1
23​	5​	10 2 5 1 8
24​	5​	10 2 1 8 5
25​	5​	10 2 1 5 8
26​	5​	10 1 8 5 2
27​	5​	10 1 8 2 5
28​	5​	10 1 5 8 2
29​	5​	…

<tbody>
</tbody>

It won't do more than one column.

This is exactly what is wanted. Thank you. Is there by any chance a PERMUTATION version to this exact thing that will take into consideration excel row limit of 1048576 and move to the next column and continue permutation until it is finished?

 

[shg]

Is there by any chance a PERMUTATION version to this exact thing ...

Those are permutations.

... that will ... move to the next column

Nope.

 

[Eager_For_Knowledge]

This is brilliant work my friend, just brilliant its exactly what i wanted. Thank you.

Is there by any chance a PERMUTATION version to this exact thing that will take into consideration that each number is between 1-35 and excel row limit of 1048576 which moves to the next column and continue permutation until it is finished?

 

[ExcelLoverMan]

Does anyone have a macro that reads 7 numbers and creates a list of all combinations of 5? I'd need to type the 7 numbers each time and then run the macro. Can anyone help? Thanks
John