This documentation is archived and is not being maintained.

ListObjects Object

Office 2007
A collection of all the ListObject objects on a worksheet. Each ListObject object represents a table in the worksheet.

Remarks

Use the ListObjects property of the Worksheet 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



Show: