LBound

Returns the smallest available subscript for the indicated dimension of an array.

Syntax

LBound(arrayname[, dimension])

The Lbound syntax has these parts:

Part Description
arrayname Name of the array variable; follows standard variable naming conventions.
dimension Whole number 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.

Remarks

The LBoundis used with the UBoundto determine the size of an array. Use the UBoundto find the upper limit of an array dimension.

The default lower bound for any dimension is always 0.