ListObject.Unlist Method
Removes the list functionality from a ListObject object.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub Unlist
'Usage
Dim instance As ListObject
instance.Unlist()
void Unlist()
Remarks
After you use this method, the range of cells that made up the list will be a regular range of data.
This property returns Nothing.
Running this method leaves the cell data, formatting, and formulas in the worksheet. The Total row is also left intact. This method removes any link to a Microsoft Windows SharePoint Services site. AutoFilter and the Insert row are also removed from the list.