LBound
Returns a Long containing the smallest available subscript for the indicated dimension of an array.
Syntax: LBound( arrayname [ , dimension ] )
- arrayname
- required The name of the array variable; follows standard variable naming conventions.
- dimension
- optional A Long indicating which dimension’s lower bound is returned. Use 1 for the first dimension, 2 for the second, and so on. If dimension is omitted, 1 is assumed.
LBound is used together with UBound to determine the size of an array.
For an array Dim A(1 To 100, 0 To 3, -3 To 4), LBound returns:
| Statement | Return value |
|---|---|
LBound(A, 1) | 1 |
LBound(A, 2) | 0 |
LBound(A, 3) | -3 |
The default lower bound for any dimension is either 0 or 1, depending on the Option Base setting. Arrays created with the Array function are zero-based regardless of Option Base. Arrays whose dimensions are set with the To clause in Dim, Private, Public, ReDim, or Static can have any integer lower bound.
Example
This example uses LBound to return the smallest available subscript for the indicated dimension of an array.
Dim Lower As Long
Dim MyArray(1 To 10, 5 To 15, 10 To 20) ' Multidimensional array.
Dim AnyArray(10)
Lower = LBound(MyArray, 1) ' Returns 1.
Lower = LBound(MyArray, 3) ' Returns 10.
Lower = LBound(AnyArray) ' Returns 0 or 1, per Option Base.
See Also
- UBound function
- IsArray, IsArrayInitialized functions