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:
VBScriptSelect and copy to clipboard
Dim n, A
A = Array(100, 6, 15)
n = UBound(A, 1) 'Returns 100
n = UBound(A, 2) 'Returns 6
n = UBound(A, 3) 'Returns 15