View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default length of an array

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?