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
Name | Returns | Description |
---|---|---|
|
| 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 |
|
| The |
Common Collection Methods
Name | Returns | Parameters | Description |
---|---|---|---|
|
|
| Returns the object from the collection with the |
Common ...
Get Excel® 2007 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.