how to generate set of combinations from n-integers in excel/vba

hi guys, i m really confused could you help me pls!!
i ve got n integers (lets say n=5) how can i make excel/vba generate all possible combinations of 1, 2, 3 ... 5 digits from these n integers?

e.g. for n=5, the output should be

12345
1234
1235
...
123
124
125
...

12
13
14
15
23
...

1
2
3
4
5



thanks a lot!!!

Originally Posted by shg

Perhaps you can adapt this: http://www.box.net/shared/nqljsd3nlu

thanks a lot for help. i had a look at the file, but i m not sure i get how to change the solution in the file to adopt my question...