Hello, I have a list of 10 Variables within an MS excel worksheet. Each variable is in a separate cell (row of 10) adjacent to a number corresponding to that variable (1-10). I would like to write a script in VBA to calculate all the permutations of these 10 variables combined and separated by commas. (i.e. Cell b1 = small, b2 = medium, b3 = big...permutations = (1) big, small, medium; (2) big, medium, small; (3) medium, small, big; (4) medium, big, small; (5) small, medium, big; (6) small, big, medium.
How can I automated this on a larger scale for more variables and enter each array within a separate cell.
I am new to this but am hoping with the logic I can finish up the coding myself.