UBOUND(arrayname [,dimension]) |
Returns the largest subscript in a given dimension of an array (Long). |
| arrayname | The 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 avTemporary(1 To 100, 0 To 3, -3 To 4) As String
UBound(avTemporary, 1) = 100
UBound(avTemporary, 2) = 3
UBound(avTemporary, 3) = 4
UBound(avTemporary) = 2
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top