Think Tom Ogilvy just posted this response in .public.excel:
Code by Myrna Larson that does this:
http://tinyurl.com/cdjck
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"tradersm" wrote in message
...
I had one more question:
let's say i have a row of numbers:
1 2 3 4 5 6 7 8 9 etc
and I want to find and display all the combinations of 2, and 3
for 2:
1-2
1-3
1-4
etc
and for 3
1-2-3
1-2-4
1-2-5
etc
have any idea how to do that?
TIA!