Description:
Returns the largest available index for the indicated dimension of an array.
Syntax:
UBound(array As String, [dimension As Integer]) As Integer
Calling:
n = UBound(array[, dimension])
Parameters:
| array | (String) the array variable |
|---|
| dimension | [optional] (Integer) Whole number indicating which dimension's upper index is returned. Use 1 for the first dimension, 2 for the second, etc.. If not set, then 1 is assumed. |
|---|
Note:
The
UBound and
LBound functions are used to determine the size of an array. Use the
LBound function to find the lower limit of an array dimension.
Example:
n = UBound(A, 1) ' Returns 100
n = UBound(A, 2) ' Returns 6
n = UBound(A, 3) ' Returns 15