Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Understanding Objects, Collections, Properties, and Methods
A group of similar objects is known as a collection . For example, the Workbooks
collection consists of all the open workbooks. Each Workbook object in that
collection can contain other objects, a few of which follow:
A Worksheet object
A Chart object (a Chart sheet, not an embedded chart)
A Name object
As you might expect, these objects also form collections. All the Worksheet
objects in a particular workbook make up the Worksheets collection. And these
objects, in turn, can contain other objects. A Worksheet object, for example, can
contain many other objects, which include the following:
A ChartObject object (the container for an embedded chart)
A Range object
A PageSetup object
A PivotTable object
If this seems confusing, trust me, it will make sense, and you’ll eventually
realize that this whole object hierarchy thing is quite logical and well structured. By the
way, the complete Excel object model is diagrammed in the VBA help system.
Figure 15-1 shows an example.
Figure 15-1: Using the help system to find out about objects
Search JabSto ::




Custom Search