UBound Function

λ°°μ—΄μ˜ 졜고 ν•œλ„λ₯Ό κ΅¬ν•©λ‹ˆλ‹€.

Syntax:


UBound (ArrayName [, Dimension])

Return value:

Long

Parameters:

ArrayName: 졜고(Ubound) λ˜λŠ” μ΅œμ €(LBound) ν•œλ„λ₯Ό 확인할 λ°°μ—΄μ˜ μ΄λ¦„μž…λ‹ˆλ‹€.

[Dimension]: 졜고(Ubound) λ˜λŠ” μ΅œμ €(LBound) ν•œλ„λ₯Ό ꡬ할 차원을 μ§€μ •ν•˜λŠ” μ •μˆ˜μž…λ‹ˆλ‹€. 값을 μ§€μ •ν•˜μ§€ μ•ŠμœΌλ©΄ 첫 번째 μ°¨μ›μ˜ ν•œλ„κ°€ κ΅¬ν•΄μ§‘λ‹ˆλ‹€.

Error codes:

5 잘λͺ»λœ ν”„λ‘œμ‹œμ € ν˜ΈμΆœμž…λ‹ˆλ‹€.

9 λ²”μœ„λ₯Ό λ²—μ–΄λ‚œ μ•„λž˜ μ²¨μžμž…λ‹ˆλ‹€.

Example:


Sub VectorBounds
    Dim v(10 To 20) As String
    Print LBound(v()) ' 10
    Print UBound(v) ' 20
End Sub
 
Sub TableBounds
    Dim t(10 To 20,-5 To 70) As Currency
    Print LBound(t), UBound(t()) ' 10  20
    Print LBound(t(),2) ' -5
    Print UBound(t,2) ' 70
End Sub