ListObjects Collection [Excel 2003 VBA Language Reference]
Worksheet ListObjects ListObject 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
Properties | Application Property | Count Property | Creator Property | Item Property | Parent Property
Methods | Add Method
Parent Objects | Worksheet
Child Objects | ListColumns | ListRows | QueryTable | Range | XmlMap
See Also | ListColumns Collection | ListRows Collection