Can someone explain in plain english what does it means Ubound & Lboun
?
How to use the Ubound & Lbound in the array?

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 onward
(A3:D72)

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

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