ListObject.Delete Method (Excel)
Deletes the ListObject object and clears the cell data from the worksheet.
Syntax
expression .Delete
expression A variable that represents a ListObject object.
Remarks
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.)