Microsoft Office Tutorials and References
In Depth Information
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
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.
Search JabSto ::




Custom Search