通过

Application.SelectResourceField Method

  • 项目
Project Developer Reference

Selects a resource field.

Syntax

expression.SelectResourceField(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 field to select.
Column Required String The name of the column containing the field to select.
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 field.
Height Optional Long The number of rows to select in addition to the active field.
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 "Name" column and the next two columns of the third and fourth rows.

Visual Basic for Applications 
  Sub Select_ResourceField()

ViewApply Name:="&Resource Sheet"
SelectResourceField Row:=3, Column:="Name", RowRelative:=False, Width:=2, Height:=1



End Sub

See Also