This documentation is archived and is not being maintained.

ListObjects Collection [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects

A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.

Using the ListObjects Collection

Use the ListObjects property of the Worksheet object to return the ListObjects collection. The following example creates a new ListObjects collection which represents all the lists in a worksheet.

			Set myWorksheetLists = Worksheets(1).ListObjects

Methods | Add Method

Parent Objects | Worksheet

Child Objects | ListColumns | ListRows | QueryTable | Range | XmlMap