ListObject.Unlist Method

Syntax

expression.Unlist

expression A variable that represents a ListObject object.

Remarks

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 is also removed from the list.

Example

The following example removes the list features from a list on a worksheet.

Sub DeList() Dim wrksht As Worksheet Dim objListObj As ListObject Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set objListObj = wrksht.ListObjects(1) objListObj.Unlist End Sub

See also:

• ListObject Object
• ListObject Object Members