Description:
Returns the largest available index for the indicated dimension of an array.
Syntax:
UBound(array, [dimension])
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.
Example1:
VBScriptSelect and copy to clipboard
Dim n, A
A = Array(100, 6, 15)
n = UBound(A, 1) 'Returns 2Example2:
VBScriptSelect and copy to clipboard
Dim n1, n2, arr(3,5)
n1 = UBound(arr, 1) 'Returns 3
n2 = UBound(arr, 2) 'Returns 5