Referring to Ranges

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

Object

Application Application Application Worksheet

Property

ActiveCell Range Selection Cells

Continued on next page

Table 8.1: Objects You Can Use to Obtain a Reference to a Range (continued)

Object

Worksheet Worksheet Worksheet Worksheet

Property

Columns

Range

Rows

UsedRange

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?

0 0

Post a comment