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

Application

Application

Read-only. Returns a reference to the owning application of the current object — Excel, in this case

Count

Long

Read-only. Returns the number of objects in the collection

Creator

Long

Read-only. Returns a Long number that describes whether or not the object was created in Excel

Parent

Object

The Parent object is the owning object of the collection object. For example, Workbooks. Parent returns a reference to the Application object

Common Collection Methods

Name

Returns

Parameters

Description

Item

Single Object

Index as Variant

Returns the object from the collection with the Index value specified by the Index parameter. The Index value may also specify a unique string key describing one of the objects in the collection

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.