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