UBound Function

Returns the upper boundary of an array.

Синтаксис

UBound (ArrayName [, Dimension])

Return value:

Integer

Parameters:

ArrayName: Name of the array for which you want to determine the upper (Ubound) or the lower (LBound) boundary.

[Dimension]: Integer that specifies which dimension to return the upper(Ubound) or lower (LBound) boundary for. If no value is specified, the boundary of the first dimension is returned.

Error codes:

5 Invalid procedure call

9 Index out of defined range

Намуна

Sub ExampleUboundLbound

Dim sVar(10 To 20) As String

    Print LBound(sVar())

    Print UBound(sVar())

End Sub

Sub ExampleUboundLbound2

Dim sVar(10 To 20,5 To 70) As String

    Print LBound(sVar()) ' Returns 10

    Print UBound(sVar()) ' Returns 20

    Print LBound(sVar(),2) ' Returns 5

    Print UBound(sVar(),2) ' Returns 70

End Sub