AutoCorrect.AutoExpandListRange Property (Excel)

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 .

Syntax

expression. AutoExpandListRange

expression A variable that represents an [AutoCorrect](./Excel.AutoCorrect(Graph property).md) object.

Example

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

Sub SetAutoExpand 
 
 Application.AutoCorrect.AutoExpandListRange = TRUE 
 
End Sub

See also

AutoCorrect Object