Description:
Returns the largest available index for the indicated dimension of an array.
Syntax:
Integer UBound(String array, [Integer dimension])
Parameters:
| array | (String) the array variable |
|---|
| dimension | [optional] (Integer) Integer 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