Page 190 - Microsoft Office Excel 2003 Programming Inside Out

Part 3: The Excel Object Model
Microsoft Office Excel 2003 Programming Inside Out

Table 8-1 lists the methods available to the Range object and describes how the method
affects which cells are selected.

Table 8-1. Range Selection Methods
Method Action Performed
.End(xlDown) Extends range downward.
.End(xlUp) Extends range upward.
.End(xlToRight) Extends range to the right.
.End(xlToLeft) Extends range to the left.
.SpecialCells(xlCellTypeAllFormatConditions) Extends range to include cells with any
formatting changes applied. Excel begins
Chapter 8
searching from cell A1, not from the
ActiveCell.
.SpecialCells(xlCellTypeAllValidation) Extends range to first cell containing
validation rules.
.SpecialCells(xlCellTypeBlanks) Extends range to first blank cell.
.SpecialCells(xlCellTypeComments) Extends range to first cell containing a
comment.
.SpecialCells(xlCellTypeConstants) Extends range to first cell containing a
constant.
.SpecialCells(xlCellTypeFormulas) Extends range to first cell containing a
formula.
.SpecialCells(xlCellTypeLastCell) Extends range to the left and downward to
the cell last used.
.SpecialCells(xlCellTypeSameFormatConditions) Extends range to first cell containing the
same formatting conditions.
.SpecialCells(xlCellTypeSameValidtion) Extends range to first cell containing the
same validation rules.
.SpecialCells(xlCellTypeVisible) Extends range to all visible cells.
.EntireColumn Extends range to entire column.
.EntireRow Extends range to entire row.

164