UBound Function

Syntax

UBound(arrayvar[, dimension])

Group

Variable Info

Description

Return the highest index.

Parameters

Parameters	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.

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

See also

LBound( )