# Visual Basic for Applications Reference

**Visual Studio 6.0**

# LBound Function

Returns a Long** **containing the smallest available subscript for the indicated dimension of an array.

**Syntax**

**LBound(***arrayname*[**, ***dimension*]**)**

The **LBound** function syntax has these parts:

Part | Description |

arrayname | Required. Name of the array variable; follows standard variable naming conventions. |

dimension | Optional; Variant (Long). 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 **LBound** function is used with the **UBound** function to determine the size of an array. Use the **UBound** function to find the upper limit of an array dimension.

**LBound** returns the values in the following table for an array with the following dimensions:

```
Dim A(1 To 100, 0 To 3, -3 To 4)
```

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 setting of the **Option** **Base** statement. The base of an array created with the **Array** function is zero; it is unaffected by **Option Base**.

Arrays for which dimensions are set using the **To** clause in a **Dim**, **Private**, **Public**, **ReDim**, or** Static** statement can have any integer value as a lower bound.