a more general determination for a single dimension:

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

--
Regards,
Tom Ogilvy

"RB Smissaert" wrote:

Lookup UBound in the VBA help.

Dim Arr(1 to 100) as String

MsgBox UBound(Arr)

This will give 100

RBS

"april27" wrote in message
...
is there any command (like in java) which gives you the length of an
array?