LBound

This function determines the smallest available subscript for the indicated dimension of an array.

Syntax

LBound(arrayname, [dimension])

Parameters

arrayname

Name of the array variable; follows standard variable naming conventions.

dimension

Whole number that indicates 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.

Return Values

Returns a subscript.

Remarks

Use LBound with UBound to determine the size of an array. Use UBound to find the upper limit of an array dimension.

The default lower bound for any dimension is always 0.