UBound Function

Syntax:

UBound(arrayvar[, dimension])

Group:

Variable Info

Description: 

Returns the highest index.

Parameters:

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.

Example:

Sub Main
  Dim A(3,6)
  Debug.Print UBound(A) ' 3
  Debug.Print UBound(A,1) ' 3
  Debug.Print UBound(A,2) ' 6
EndSub

See Also:

LBound( )