At some point, I read or was told that Eskimos have something like 26 words for snow. Well there aren't 26 different ways to refer to a range, but there are a lot. Table 8.1 lists some of the objects that contain properties that refer to a range.
Table 8.1: Objects You Can Use to Obtain a Reference to a Range
Application Application Application Worksheet
ActiveCell Range Selection Cells
Continued on next page
Table 8.1: Objects You Can Use to Obtain a Reference to a Range (continued)
Worksheet Worksheet Worksheet Worksheet
As you can see, you have many different ways to obtain a reference to a Range object, and this table doesn't even include the many ways you can refer to a range using the Range object itself.
Listing 8.1 demonstrates how you can use the Application object to obtain a reference to specific ranges.
Was this article helpful?