Hi Im new to this forum,
I have been away from using VBA for a number of years so not used to 2010 version. I was hoping not to ask this but browsing through the answers to a similar questions are close but not quite there. Anyway I have 27 numbers 1 - 27. And I need help to make a macro that can list in rows of 6 columns 4 number permutations (Single n0 in each cell) 6 numbers = 15 x 4 n0 perms, no 4 number permutation in any of the next rows are to duplicate any previous row. From my calcs there should be 17550 perms of 4 in turn 1170 rows of 6 n0s. Can any 1 guide me in writing this macro.. Any help will be much appreciated..
Kind regards
theborg