length of an array

[Guest]

is there any command (like in java) which gives you the length of an array?

 

[RB Smissaert]

Lookup UBound in the VBA help.

Dim Arr(1 to 100) as String

MsgBox UBound(Arr)

This will give 100

RBS

 

[Bob Phillips]

Use

UBound(Arr) - LBound(Arr) + 1

in case it doesn't start at 1.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

a more general determination for a single dimension:

Dimensionsize = Ubound(a) - lbound(a) + 1