Defining a Range Object

As witness to the importance of the Range object, there are a total of 113 members (properties and methods) throughout the Excel object model that return a Range object. This number drops to 51 if we count only distinct member names, as shown in Table 19-2. (For instance, BottomRightCell is a property of 21 different objects, as is TopLeftCell.)

Table 19-2. Excel Members That Return a Range Object

_Default

End

Range

ActiveCell

EntireColumn

RangeSelection

BottomRightCell

EntireRow

RefersToRange

Cells

Find

Resize

ChangingCells

FindNext

ResultRange

CircularReference

FindPrevious

RowDifferences

ColumnDifferences

GetPivotData

RowRange

ColumnRange

Intersect

Rows

Columns

Item

SourceRange

CurrentArray

LabelRange

SpecialCells

CurrentRegion

Location

TableRange1

DataBodyRange

MergeArea

TableRange2

DataLabelRange

Next

ThisCell

DataRange

Offset

TopLeftCell

Dependents

PageRange

Union

Destination

PageRangeCells

UsedRange

DirectDependents

Precedents

VisibleRange

DirectPrecedents

Previous

Let us take a look at some of the more prominent ways to define a Range object.

0 0

Post a comment