ListObject.Unlist (Excel)

Removes the list functionality from a ListObject object. After you use this method, the range of cells that made up the list will be a regular range of data.

Running this method leaves the cell data, formatting, and formulas on the worksheet. The Total row is also left intact. This method removes any link to a Microsoft SharePoint Foundation site. AutoFilter is also removed from the list.

ActiveCell.ListObject.Unlist