Remarks

Use the property of the object to return the ListObjects collection.

Example

The following example creates a new ListObjects collection which represents all the tables in a worksheet.

Visual Basic for Applications
Set myWorksheetLists = Worksheets(1).ListObjects

See also: