Appendix A. Excel 2007 Object Model
Most of the objects in the Excel object model have objects with associated collections. The collection object is usually the plural form of the associated object. For example, the
Worksheets collection holds a collection of
Worksheet objects. For simplicity, each object and associated collection will be grouped together under the same heading.
Common Properties with Collections and Associated Objects
In most cases, the purpose of the collection object is only to hold a collection of the same objects. The common properties and methods of the collection objects are listed in the following section. Only unique properties, methods, or events are mentioned in each object section.
Common Collection Properties
Read-only. Returns a reference to the owning application of the current object — Excel, in this case
Read-only. Returns the number of objects in the collection
Read-only. Returns a
Common Collection Methods
Returns the object from the collection with the