UBound Function

๋ฐฐ์—ด์˜ ์ตœ๊ณ  ํ•œ๋„๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:

UBound (ArrayName [, Dimension])

๋ฐ˜ํ™˜ ๊ฐ’:

Integer

๋งค๊ฐœ ๋ณ€์ˆ˜:

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