Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UBound of multi-dimensional array?
Hi Paul,
You can use the optional second argument to the UBound function. From the VB help file: dimension: Optional; Variant (Long). Whole number indicating which dimension's upper bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] paulharvey wrote: This is a simple question... I'm sure someone out there knows the answer to it... I have a 2-D array... ReDim A(1 to x, 1 to y) I need to know the upper-bound of the second dimension of A (which is y), but UBound(A) only gives me x. Thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Viewing Multi dimensional array | Excel Programming | |||
Viewing Multi dimensional array | Excel Programming | |||
Enumerating a multi-dimensional array | Excel Programming | |||
Problem with Multi-Dimensional Array | Excel Programming | |||
How to declare Multi-dimensional dynamic array? | Excel Programming |