Programming Reference Manual

UBound

 
Syntax
 
UBound(arrayvar[, dimension])
Description
Return the highest index.
 
Parameter
Description
arrayvar 
Return the highest index for this array variable.
dimension 
Return the highest index for this dimension of arrayvar. If this is omitted then return the highest index for the first dimension.
See Also
LBound.
Example
 
Sub Main
    Dim A(3,6)
    Debug.Print UBound(A)   ' 3
    Debug.Print UBound(A,1) ' 3
    Debug.Print UBound(A,2) ' 6
End Sub