UBOUND(arrayname [,dimension])

Returns the largest subscript in a given dimension of an array (Long).


The array (Variant).


The dimension (Long).

This function is used with the LBound() function to determine the size of an array.
Use the LBound() function to find the lower limit of an array dimension.
In .NET this is available in Microsoft.VisualBasic namespace.

Dim A(1 To 100, 0 To 3, -3 To 4) 
UBound(A, 1) = 100
UBound(A, 2) = 3
UBound(A, 3) = 4

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited