list permutations

[scott]

I need a macro that will produce a list of permutations of the numbers 1-5.
There should be 120 permutations
ex.
1 2 3 4 5
2 1 3 4 5
1 2 4 3 5
etc.

 

[RB Smissaert]

Have a look here:
http://www.j-walk.com/ss/excel/tips/tip46.htm
You only will need some minor adaptations to that code.

RBS