Lbound function is to identify lowest number for array sequence by default is 0, with Option Base 1 on top of module then become 1 otherwise specify. For example Dim myArry(10) then Lbound = 0, with Option Base 1 then LBound = 1, another example Dim myArray(5 to 10) then Lbound = 5. Usually we Lbound pair with Ubound function to loop array from lowest to highest value.
Syntax : Lbound(arrayname, Dimension) , Returns : Numeric
Example of Dimension
MyArray(10) = Single Dimension
MyArray(5 to 10) = Single Dimension
MyArray(2 to 10, 5 to 12) = 2 Dimension (Key in 1 or 2 for dimension)
MyArray(2 to 10, 5 to 12, 4 to 10) = 3 Dimension (Key in 1, 2 or 3) and etc
VBA Vode:
Option Base 1 ' Set default array subscripts to 1.
Sub Examples_LBoundArray()
Dim myArray1(10)
Dim myArray2(5 To 10)
Dim myArray3(5 To 10, 3 To 15)
Debug.Print LBound(myArray1) 'Answer = 1 (Option Base 1)
Debug.Print LBound(myArray2) 'Answer = 5
Debug.Print LBound(myArray3, 1) 'Answer = 5
Debug.Print LBound(myArray3, 2) 'Answer = 3
End Sub
Note:
For single dimension array we don't have to specify dimension in syntax.
Other Reference-Lbound-function
Practice makes perfect. Thank You.
macro enabled excel
excel macro
vba coding
vba code
