通过

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 
  Sub Select_Cell()

ViewApply Name:="&Gantt Chart"
SelectCell Row:=4, Column:=3, RowRelative:=False



End Sub

See Also