Application.ExtendList property (Excel)
True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list. Read/write Boolean.
expression A variable that represents an Application object.
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 side of the list.
This example sets Excel to not apply formatting and formulas to data subsequently added to an existing list.
Application.ExtendList = False
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.