excel-vba Converting an Excel Table to a normal range


Example

Dim lo as ListObject

Set lo = Sheet1.ListObjects("Table1")
lo.Unlist