Concantenate Loop

[firebugabc]

Hi,

Lets say I have data in 5 cells in sheet1:

a1 b1 c1 d 1 e1

How can I write a loop to get all possible combinations of the text in each cell written to cells in sheet2?

So, in this example there would be 120 strings created.

Thanks

[austenr]

Sounds like a homework problem

[firebugabc]

Actually it is a real world problem, if I was still in school I could answer it myself. I am dumb in my old age

[XLGibbs]

Sounds tricky...I guess the first question is why do you need to iterate through all the variations? Is the goal to simply create a list of them?

It can be done, but I will have to dig through some code to find the right mix...will post a sample back if I find it before too lpng.