ListObject.Unlist Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Removes the list functionality from a ListObject object.
public:
void Unlist();
public void Unlist ();
Public Sub 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.