ListObjects Object (Excel)

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 theWorksheet object to return the ListObjects collection.

Example

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

Set myWorksheetLists = Worksheets(1).ListObjects

Methods

Name
Add

Properties

Name
Application
Count
Creator
Item
Parent

See also

Excel Object Model Reference