ListObject.Unlist Method

Definition

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.

Applies to