通过

Application.SelectRow Method

  • 项目
Project Developer Reference

Selects one or more rows.

Syntax

expression.SelectRow(Row, RowRelative, Height, Extend, Add)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Row Optional Long The number of the row to select. The default is the active row.
RowRelative Optional Boolean True if the location of the new selection is relative to the active selection. The default value is True.
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 adds row numbers 3 through 5 to the current selection.

Visual Basic for Applications 
  Sub Select_Row()
    
   'Activate Gantt Chart
    ViewApply Name:="&Gantt Chart"
    SelectRow Row:=3, RowRelative:=False, Height:=2, Add:=True
End Sub

See Also