length of array

aadarsh · Mar 1st 2005

how do i find the length of an array, which has been declared as

Code

Dim abcarray() As Variant

pradeep_atm · Mar 1st 2005

Re: length of array

Hi Aadarsh,

Try this:
[vba]
Ubound(array)
[/vba]

HTH.

aadarsh · Mar 1st 2005

Re: length of array

Thanx

pstraton · Nov 26th 2013

Re: length of array

The above solution doesn't work for zero-based arrays. Here's a complete example.

Code

Option Base 0  'Un-comment for zero-based arrays
'Option Base 1   'Un-comment for one-based arrays


Sub ShowArrayLen()
    Dim abcarray() As Variant


    ReDim abcarray(3)   'i.e. some run-time array size value


    MsgBox "Range: " & LBound(abcarray) & " to " & UBound(abcarray)
    MsgBox "Length: " & UBound(abcarray) - LBound(abcarray) + 1
    MsgBox "Ubound: " & UBound(abcarray)    'does not = length for zero-based arrays!
End Sub

Display More

length of array

Participate now!

Share