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