Info

Figure 5.1

Some Excel properties also can be objects.

Figure 5.1

Some Excel properties also can be objects.

In other words, lower-level objects in the object hierarchy are really just properties of their parent objects. This idea will often help you to reduce the length of a hierarchical path (and thus reduce the abuse your typing fingers must bear). For example, consider the following object path:

Application.ActiveWindow.ActiveCell.Font.Italic

Here, an object such as ActiveCell implicitly refers to the ActiveWindow and Application objects, so you can knock the path down to size, as follows:

ActiveCell.Font.Italic

0 0

Post a comment