_Application.ExtendList Property

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property ExtendList As Boolean
    Get
    Set
'Usage
Dim instance As _Application
Dim value As Boolean

value = instance.ExtendList

instance.ExtendList = value
bool ExtendList { get; set; }

Property Value

Type: System.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.

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace