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 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.