LBound Function

āĻāĻ•āϟāĻŋ āĻ…ā§āϝāĻžāϰ⧇āϰ āύāĻŋāĻŽā§āύ āϏ⧀āĻŽāĻž āĻĒā§āϰāĻĻāĻžāύ āĻ•āϰ⧇āĨ¤

Syntax:


LBound (ArrayName [, Dimension])

Return value:

Long

Parameters:

ArrayName: āĻ…ā§āϝāĻžāϰ⧇āϰ āύāĻžāĻŽ āϝāĻžāϰ āϜāĻ¨ā§āϝ āφāĻĒāύāĻŋ āĻ…ā§āϝāĻžāϰ⧇ āĻŽāĻžāĻ¤ā§āϰāĻžāϰ āϊāĻ°ā§āĻ§ā§āĻŦ (Ubound) āĻ…āĻĨāĻŦāĻž āύāĻŋāĻŽā§āύ (LBound) āϏ⧀āĻŽāĻžāύāĻž āĻĒā§āϰāĻĻāĻžāύ āĻ•āϰāϤ⧇ āϚāĻžāύāĨ¤

[Dimension]: āχāύāϟāĻŋāϜāĻžāϰ āϝāĻž āϊāĻ°ā§āĻ§ā§āĻŦ (Ubound) āĻ…āĻĨāĻŦāĻž āύāĻŋāĻŽā§āύ (LBound) āϏ⧀āĻŽāĻžāύāĻžāϰ āϜāĻ¨ā§āϝ āϕ⧋āύ āĻŽāĻžāĻ¤ā§āϰāĻž āĻĒā§āϰāĻĻāĻžāύ āĻ•āϰāĻž āĻšāĻŦ⧇ āϤāĻž āωāĻ˛ā§āϞ⧇āĻ– āĻ•āϰ⧇ āĻĨāĻžāϕ⧇āĨ¤ āϝāĻĻāĻŋ āĻāĻ•āϟāĻŋ āĻŽāĻžāύ āωāĻ˛ā§āϞ⧇āĻ– āĻ•āϰāĻž āύāĻž āĻĨāĻžāϕ⧇, āϤāĻžāĻšāϞ⧇ āĻĒā§āϰāĻĨāĻŽ āĻŽāĻžāĻ¤ā§āϰāĻžāϟāĻŋ āϧāĻžāϰāĻŖāĻž āĻ•āϰ⧇ āĻ¨ā§‡ā§ŸāĻž āĻšā§ŸāĨ¤

Error codes:

5 Invalid procedure call

9 Index out of defined range

Example:


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

Please support us!