UBound Function [Runtime]

From LibreOffice Help
Jump to: navigation, search

Returns the upper boundary of an array.


UBound (ArrayName [, Dimension])

Return value:



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