Ubound with Muliple Columns

[Rocky0201]

Hi..

I have defined vAry as a Variant. I ReDim this to have 2 columns:

ReDim vAry(330,38)

How do I use Ubound on the second column only (the 38 element column)?

I am trying to use a For loop but only on the second column.

For I = 1 to vAry(???)

This this possible?

If I code Ubound(vAry(0,0)) i receive Type mismatch.

Thanks...

 

[Leith Ross]

Hello Rocky0201,

The UBound takes 2 arguments: The array name and the dimension number. In your array vAry(330,38), the upper boundaries are dimension 1 is 330, and dimension 2 is 38. Your code then would be...

For I = 1 to UBound(vAry, 2)​

 

[Rocky0201]

Thanks Leith... This is perfect. Thanks for the explanation...

 

[Leith Ross]

Hello Rocky0201,

You're welcome. If you have your VBA Help files installed you can find this information there also.