Application.SelectCell Method

Project Developer Reference

Selects a cell.

Syntax

expression.SelectCell(Row, Column, RowRelative)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data Type	Description
Row	Optional	Long	The row number (RowRelative is False) or the relative row position (RowRelative is True) of the cell to select.
Column	Optional	Integer	The column number of the cell to select.
RowRelative	Optional	Boolean	True if the row number is relative to the active cell. The default value is True.

Return Value
Boolean

Remarks

Using the SelectCell method without specifying any arguments retains the current cell as the active cell.

Example
The following example selects the third field in the fourth row of the Gantt Chart.

Visual Basic for Applications

Visual Basic for Applications
`Sub Select_Cell() ViewApply Name:="&Gantt Chart" SelectCell Row:=4, Column:=3, RowRelative:=False` `End Sub`

  Sub Select_Cell()
ViewApply Name:="&amp;Gantt Chart"
SelectCell Row:=4, Column:=3, RowRelative:=False

End Sub

Additional resources