SelectRange Method

Selects one or more cells.

Syntax

expression**.SelectRange(Row, Column, RowRelative, Width, Height, Extend, Add)**

*expression   *     Optional. An expression that returns an Application object.

Row    Required Long. The number of the row containing the cell to select.

Column    Required Integer. The number of the column containing the cell to select. (Columns are numbered from left to right, starting with 2.)

RowRelative    Optional Boolean. True if the location of the new selection is relative to the active selection. The default value is True.

Width    Optional Long. The number of columns to select in addition to the active cell.

Height    Optional Long. The number of rows to select in addition to the active cell.

Extend    Optional Boolean. True if the active selection is extended into the new selection. The default value is False.

Add    Optional Boolean. True if the new selection is added to the active selection. The default value is False.

Applies to | Application Object

See Also | SelectAll Method | SelectBeginning Method | SelectCell Method | SelectCellDown Method | SelectCellLeft Method | SelectCellRight Method | SelectCellUp Method | SelectEnd Method | SelectResourceCell Method | SelectResourceColumn Method | SelectResourceField Method | SelectRowEnd Method | SelectRowStart Method | SelectSheet Method | SelectTaskCell Method | SelectTaskColumn Method | SelectTaskField Method | SetActiveCell Method