Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Peter T wrote:
I think what you are trying to do with this - Function foo10(ParamArray x()) z = UBound(x(0)(1)) End Function is really - Function foo10(ParamArray x()) z = UBound(Application.Index(x(0), 1)) End Function or depending which dimension - z = UBound(Application.Index(x(0), 2)) Regards, Peter T Thanks for responding. What I'm really trying to do is understand the following line in the Locals window when z = UBound(x(0)(1)) gives a "Subscript out of range" error message: x(0)(1) Variant(1 to 4) Thanks, Alan Beban |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date anomaly | Excel Discussion (Misc queries) | |||
Sort anomaly | Excel Worksheet Functions | |||
ParamArray bugs? | Excel Programming | |||
Help with paramarray | Excel Programming | |||
ParamArray | Excel Programming |