UBound Function

αžαŸ’αžšαž‘αž”αŸ‹β€‹αž–αŸ’αžšαŸ†αžŠαŸ‚αž“β€‹αžαžΆαž„β€‹αž›αžΎβ€‹αž“αŸƒβ€‹αž’αžΆαžšαŸβ€‹αž˜αž½αž™Β αŸ”

αžœαžΆαž€αŸ’αž™β€‹αžŸαž˜αŸ’αž–αž“αŸ’αž’ αŸ–

UBound (ArrayName [, Dimension])

αžαž˜αŸ’αž›αŸƒβ€‹αžαŸ’αžšαž‘αž”αŸ‹ αŸ–

αž…αŸ†αž“αž½αž“β€‹αž‚αžαŸ‹

αž”αŸ‰αžΆαžšαŸ‰αžΆαž˜αŸ‰αŸ‚αžαŸ’αžš αŸ–

ArrayName αŸ– αžˆαŸ’αž˜αŸ„αŸ‡β€‹αž“αŸƒβ€‹αž’αžΆαžšαŸ αžŠαŸ‚αž›β€‹αž’αŸ’αž“αž€β€‹αž…αž„αŸ‹β€‹αž€αŸ†αžŽαžαŸ‹β€‹αž–αŸ’αžšαŸ†αžŠαŸ‚αž“β€‹αžαžΆαž„β€‹αž›αžΎ (Ubound) αž¬β€‹αžαžΆαž„β€‹αž€αŸ’αžšαŸ„αž˜ (LBound)Β αŸ”

[Dimension] αŸ– αž…αŸ†αž“αž½αž“β€‹αž‚αžαŸ‹β€‹αžŠαŸ‚αž›β€‹αž”αž‰αŸ’αž‡αžΆαž€αŸ‹β€‹αžαžΎβ€‹αžœαž·αž˜αžΆαžαŸ’αžšβ€‹αžŽαžΆβ€‹αž˜αž½αž™β€‹αžŠαžΎαž˜αŸ’αž”αžΈβ€‹αžαŸ’αžšαž‘αž”αŸ‹β€‹αž–αŸ’αžšαŸ†αžŠαŸ‚αž“β€‹αžαžΆαž„β€‹αž›αžΎ (Ubound) αž¬β€‹αžαžΆαž„β€‹αž€αŸ’αžšαŸ„αž˜ (LBound)Β αŸ” αž”αŸ’αžšαžŸαž·αž“β€‹αž”αžΎβ€‹αž‚αŸ’αž˜αžΆαž“β€‹αžαž˜αŸ’αž›αŸƒβ€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αž”αž‰αŸ’αž‡αžΆαž€αŸ‹ αž–αŸ’αžšαŸ†αžŠαŸ‚αž“β€‹αž“αŸƒβ€‹αžœαž·αž˜αžΆαžαŸ’αžšβ€‹αž‘αžΈβ€‹αž˜αž½αž™β€‹αžαŸ’αžšαžΌαžœβ€‹αž”αžΆαž“β€‹αžαŸ’αžšαž‘αž”αŸ‹Β αŸ”

Error codes:

5 αž€αžΆαžšβ€‹αž αŸ…β€‹αž”αŸ‚αž”αž”αž‘β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ

9 αž›αž·αž”αž·αž€αŸ’αžšαž˜β€‹αž“αŸ…β€‹αž€αŸ’αžšαŸ…β€‹αž‡αž½αžšβ€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž€αŸ†αžŽαžαŸ‹

αž§αž‘αžΆαž αžšαžŽαŸ αŸ–

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()) REM Returns 10

    Print UBound(sVar()) REM Returns 20

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

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

End Sub