UBound

Returns a Long containing the largest available subscript for the indicated dimension of an array.

Syntax: UBound( arrayname [ , dimension ] )

arrayname

required The name of the array variable; follows standard variable naming conventions.

dimension

optional A Long indicating which dimension's upper bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed.

UBound is used together with LBound to determine the size of an array.

For an array Dim A(1 To 100, 0 To 3, -3 To 4), UBound returns:

Statement	Return value
UBound(A, 1)	100
UBound(A, 2)	3
UBound(A, 3)	4

Example

This example uses UBound to return the largest available subscript for the indicated dimension of an array.

Dim Upper As Long
Dim MyArray(1 To 10, 5 To 15, 10 To 20)    ' Multidimensional array.
Dim AnyArray(10)
Upper = UBound(MyArray, 1)                 ' Returns 10.
Upper = UBound(MyArray, 3)                 ' Returns 20.
Upper = UBound(AnyArray)                   ' Returns 10.

See Also

• LBound function
• IsArray, IsArrayInitialized functions