Macro recorded to split cells - edit to allow for any cell to be clicked and separatd

That code is way bloated, one of the cons of recording macros. What exactly are you trying to do? It may be easier to devise code from scratch than to try and decipher what the code is doing.

I have a macro that outputs combinations of 3 numbers out of 6 numbers, which is 20 combinations in total, but it outputs all 20 numbers vertically in one cell, but I want to split each 3 numbers into separate cells. I have attached the macro that does this if this is easier than trying to do a macro to split the cell.

Thanks

To get this output:

Please Login or Register  to view this content.

Manually enter the first set of elements, and then in A3:C3, enter and copy down this array formula:

= NextComboWF(A2:C2, 6, 3)

.. which requires this function:

Please Login or Register  to view this content.