AutoCorrect.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.
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.
| Visual Basic for Applications |
|---|
|