A collection of all the ListObject objects on a worksheet. Each ListObject object represents a table on the worksheet.
Use the ListObjects property of the Worksheet object to return the ListObjects collection.
The following example creates a new ListObjects collection that represents all the tables on a worksheet.
Set myWorksheetLists = Worksheets(1).ListObjects