通过

Application.SelectColumn Method

  • 项目
Project Developer Reference

Selects one or more columns.

Syntax

expression.SelectColumn(Column, Additional, Extend, Add)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Column Optional Integer The number of the column to select. (Columns are numbered from left to right, starting with 2.) The default is the active column.
Additional Optional Integer The number of columns to select in addition to the active column.
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 the fourth column of the Gantt Chart.

Visual Basic for Applications 
  Sub Select_Column()
    ViewApply Name:="&Gantt Chart"
    SelectColumn Column:=4, Extend:=False
End Sub

See Also