# UBound of multi-dimensional array?

1. ## 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

2. ## Re: UBound of multi-dimensional array?

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

3. ## Re: 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

paulharvey wrote:
> This is a simple question... I'm sure someone out there knows the
>
> 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1