Поделиться через

AutoCorrect.AutoExpandListRange Property

  • Статья
Excel Developer Reference

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

Application.AutoCorrect.<strong>AutoExpandListRange</strong> = TRUE



End Sub

See Also