ListObject.Delete method (Excel)
Deletes the ListObject object and clears the cell data from the worksheet.
expression A variable that represents a ListObject object.
If the list is linked to a SharePoint site, deleting it does not affect data on the server that is running SharePoint Foundation. Any uncommitted changes made to the local list are not sent to the SharePoint list. There is no warning that these uncommitted changes are lost.
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.