Hi Bob Philips,

Thanks for the explainations. Can you show how to do the below modul
in VBA.

I try to generate the value from the range A1:H1 into a 4 columns.
Lets say A1:H1 hold the value 11 to 18
If using the formula combin(8,4) it will give me 70 combinations.
I like the values to be insert in 4 columns from row 3 onwards
(A3:D72)

e.g.
A3=11,B3=12,C3=13,D3=14
until
A72=15,B72=16,C72=17,D72=18

Reagrds
Michae

--
Message posted from http://www.ExcelForum.com