Excel VBA LBound Function: The LBound function in VBA returns the lowest subscript for the specified dimension in the given array.

Syntax

Parameter

ArrayName (required) – This parameter represents an array for which you want to find the lowest subscript.

Dimension (optional) – This parameter specifies the dimension of the array, for which you require the lowest subscript. By default, this parameter is set to 1.

Return

This function returns the lowest subscript for the specified dimension in the given array.

Example 1

Output

0

VBA LBound Function

Example 2

Output

1

10

VBA LBound Function

Pin It on Pinterest

Share This