ListObject.Delete (Excel)

Deletes the ListObject object and clears the cell data from the worksheet.

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.

ActiveCell.ListObject.Delete