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

RBS


"scott" wrote in message
...
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.