UBound Function
āĻāĻāĻāĻŋ āĻ ā§āϝāĻžāϰā§āϰ āĻāĻā§āĻ āϏā§āĻŽāĻž āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§āĨ¤
āϏāĻŋāύāĻā§āϝāĻžāĻā§āϏ:
UBound (ArrayName [, Dimension])
āĻĒā§āϰāĻĻāĻžāύ āĻŽāĻžāύ:
Integer
āĻĒā§āϝāĻžāϰāĻžāĻŽāĻŋāĻāĻžāϰ:
ArrayName: āĻ ā§āϝāĻžāϰā§āϰ āύāĻžāĻŽ āϝāĻžāϰ āĻāύā§āϝ āĻāĻĒāύāĻŋ āĻāϰā§āϧā§āĻŦ (Ubound) āĻ āĻĨāĻŦāĻž āύāĻŋāĻŽā§āύ (LBound) āϏā§āĻŽāĻžāύāĻž āύāĻŋāϰā§āϧāĻžāϰāĻŖ āĻāϰāϤ⧠āĻāĻžāύāĨ¤
[Dimension]: āĻāύāĻāĻŋāĻāĻžāϰ āϝāĻž āĻāϰā§āϧā§āĻŦ (Ubound) āĻ āĻĨāĻŦāĻž āύāĻŋāĻŽā§āύ (LBound) āϏā§āĻŽāĻžāύāĻžāϰ āĻāύā§āϝ āĻā§āύ āĻŽāĻžāϤā§āϰāĻž āĻĒā§āϰāĻĻāĻžāύ āĻāϰāĻž āĻšāĻŦā§ āϤāĻž āĻāϞā§āϞā§āĻ āĻāϰ⧠āĻĨāĻžāĻā§āĨ¤ āϝāĻĻāĻŋ āĻā§āύ āĻŽāĻžāύ āĻāϞā§āϞā§āĻ āĻāϰāĻž āύāĻž āĻĨāĻžāĻā§, āϤāĻžāĻšāϞ⧠āĻĒā§āϰāĻĨāĻŽ āĻŽāĻžāϤā§āϰāĻž āϏā§āĻŽāĻžāύāĻž āĻĒā§āϰāĻĻāĻžāύ āĻāϰ⧠āĻĨāĻžāĻā§āĨ¤
āĻāĻĻāĻžāĻšāϰāĻŖ:
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