UBound and LBound are VBA functions to work out the lower and upper bounds
of an array.
COMBIN is a worksheet function. As such, unless you write som e code to link
them, there is no relationship.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Michael168 " wrote in message
...
Can someone explain in plain english what does it means Ubound & Lbound
?
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 onwards
(A3:D72)
e.g.
A3=11,B3=12,C3=13,D3=14
until
A72=15,B72=16,C72=17,D72=18
---
Message posted from http://www.ExcelForum.com/