AutoExpandListRange Property

Microsoft Excel Visual Basic

Show All Show All

AutoExpandListRange Property

A Boolean value indicating whether automatic expansion is enabled for lists. When you type in a cell of an empty row or column next to a list, the list will expand to include that row or column if automatic expansion is enabled. Read/write Boolean.

expression.AutoExpandListRange

expression    Required. An expression that returns one of the objects in the Applies To list.

Example

The following example enables automatic expansion of lists when typing in adjacent rows or columns.

    Sub SetAutoExpand

    Application.AutoCorrect.AutoExpandListRange = TRUE

End Sub