UBOUND(arrayname [,dimension])

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


arraynameThe array (Variant).
dimension(Optional) The dimension (Long).

REMARKS
* You cannot prefix this function with "VBA."
* You can use the LBOUND function to find the lower limit of an array dimension.
* The equivalent .NET function is Microsoft.VisualBasic.Information.UBound
* For the Microsoft documentation refer to docs.microsoft.com

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

© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited Top