Share via

ListObject.Unlist Method

  • Article
Excel Developer Reference

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

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.

Visual Basic for Applications 
  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