Application.SelectRange method (Project)

Selects one or more cells.

Syntax

expression. SelectRange( _Row_, _Column_, _RowRelative_, _Width_, _Height_, _Extend_, _Add_ )

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
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.

Return value

Boolean

Example

The following example selects columns 3 through 6 and rows 4 through 6 on the Gantt Chart.

Sub Select_Range() 
 
 ViewApply Name:="&Gantt Chart" 
 SelectRange Row:=4, Column:=3, RowRelative:=False, Width:=3, Height:=2 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.