Can somebody explain to me which part of the code to modify to write the permutations in rows versus columns and add a sheet after X amount of rows, i.e. 256.
The way I use the permutation:
I write an array of numbers, letters etc in Column A and want to compare the results visually. I enter the data from my column into ML Sheet1 with P in cell A1 and every time the code runs it creates a new worksheet by default. Then I copy paste and transpose the results to another sheet compare the output. I tried with a formula like nextperm but due to the dependence on row numbers for incrementing (I think), it does not work if copied across columns past the letter Z.
If it is too difficult to accomplish this ( I am very new to VBA) a simpler temporary solution would be to enter the results in the next available column of a worksheet instead of creating a new sheet every time the macro runs.
Thank you

Please Login or Register  to view this content.