UBound function
Summary
Upper bound of array dimension.
Syntax
UBound(arrayname, [ dimension ])
The UBound function syntax has these parts.
Part
Description
arraynameRequired. Name of the array variable; follows standard variable naming conventions.
dimensionOptional; Variant (Long). Whole number 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.
Part
Description
arraynameRequired. Name of the array variable; follows standard variable naming conventions.
dimensionOptional; Variant (Long). Whole number 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.
Example
Example
This example uses the UBound function to determine the largest available subscript for the indicated dimension of an array.
Dim Upper
Dim MyArray(1 To 10, 5 To 15, 10 To 20) ' Declare array variables.
Dim AnyArray(10)
Upper = UBound(MyArray, 1) ' Returns 10.
Upper = UBound(MyArray, 3) ' Returns 20.
Upper = UBound(AnyArray) ' Returns 10.
This example uses the UBound function to determine the largest available subscript for the indicated dimension of an array.
Dim Upper
Dim MyArray(1 To 10, 5 To 15, 10 To 20) ' Declare array variables.
Dim AnyArray(10)
Upper = UBound(MyArray, 1) ' Returns 10.
Upper = UBound(MyArray, 3) ' Returns 20.
Upper = UBound(AnyArray) ' Returns 10.