This documentation is archived and is not being maintained.

Application.ExtendList Property

Office 2007
True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list. Read/write Boolean.

Syntax

expression.ExtendList

expression   A variable that represents an Application object.

Remarks

To be extended, formats and formulas must appear in at least three of the five list rows or columns preceding the new row or column, and you must add the data to the bottom or to the right-hand side of the list.

Example

This example sets Excel to not apply formatting and formulas to data subsequently added to an existing list.

Visual Basic for Applications
Application.ExtendList = False



Show: