LBound Function

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

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

LBound (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