UBound of multi-dimensional array?

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

Take a look at "UBound Function" in VBA Help. It has good examples.


In article <paulharvey.1tv9us_1124212478.731@excelforum-nospam.com>,
paulharvey <paulharvey.1tv9us_1124212478.731@excelforum-nospam.com>
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

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