Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ubound & Lbound
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is this returning a Ubound value of zero | Excel Discussion (Misc queries) | |||
multiple file uploading - runtime error'13': type mismatch "While Counter <= UBound(FName)" | Excel Discussion (Misc queries) |