Programming Excel with VBA and .NET

Name

listobject.Unlist( )

Synopsis

Converts a list to a normal range of cells. If the list displays a totals row, that row becomes part of the range. The following code hides the totals row and then converts a list to a range:

Sub ConverToRange(  )
    Dim ws As Worksheet, lst As ListObject
    Set ws = ActiveSheet
    ' Get the first list on the worksheet.
    Set lst = ws.ListObjects(1)
    ' Convert it to a range.
    lst.Unlist
End Sub