Combinations of 1-6

[carterja80]

Hi everyone! I'm having trouble coming up with a macro to run all possible combinations of the numbers 1-6. The set I'm specifically looking to see is all combinations (or permutations?) of the specified set that are only 3 numbers long. I've seen a bunch of different macros that do a similar function on here, but their specified set is different. When I try to change the numbers in those macros, it still runs the old macro, and not the new one (with my numbers). I'm guessing I don't understand them well enough to change all the data that needs to be changed.

So, does anyone have a macro that would run all the different combinations of the numbers 1-6, only focusing on the ones that are 3 number long?

Thanks so much for the help!

[Kenneth Hobson]

Welcome to the forum!

combin<=permut

20 < 120 in the case of 6,3.

Run this from a blank sheet.

Please Login or Register  to view this content.

[carterja80]

Thank you so much, Kenneth! This is exactly what I need! Life saver!

[HankW501]

Open a new sheet. Click on Visual Basic in the Code section under the Developer tab (by default the Developer tab is not visible, so you have to activate it the first time under Excel Options). Click on Module in the Insert menu. Enter the subroutine below. Go back to the top line (Ctrl+Home) and press F5. In the main Excel window all of the 3-digit combinations of 1 through 6 will be in the first column starting at Row 2.

Please Login or Register  to view this content.