UBound of multi-dimensional array?

P

paulharvey

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
 
J

Jake Marx

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top