_Application.ExtendList Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list.

public:
 property bool ExtendList { bool get(); void set(bool value); };

public bool ExtendList { get; set; }

Public Property ExtendList As Boolean

Property Value

Boolean

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.

Applies to