UBound()

UBound() - Determines the last element of an array

Description

The Ubound() functions is used to determine the largest available subscript for the specified dimension of an array.

UBound(array[, dimension])

Parameters
The array parameter is the name of the array.

The optional dimension parameter is used to specify the dimension of a multi-dimensional array.

Example

Dim MyArray(5), Limit

Limit = UBound(MyArray) 'returns 5