Export (0) Print
Expand All

Select Method

Office 2003

Selects the specified object.

expression.Select

expression    Required. An expression that returns one of the above objects.

Selects an object in a PivotTable list.

expression.Select(Selection, ActiveObject, ScrollType, Update, Notify)

expression    Required. An expression that returns one of the above objects.

Selection   Required Object. The object to select.

ActiveObject   Required Object. The object to make active within the new selection.

PivotScrollTypeEnum can be one of these PivotScrollTypeEnum constants.
plScrollTypeAll
plScrollTypeBottom
plScrollTypeLeft
plScrollTypeNone default
plScrollTypeRight
plScrollTypeTop

Update   Optional Boolean. Determines whether the display is updated immediately. The default value is True.

Notify   Optional Boolean. This argument is not supported.

Example

This example selects the cell that is one column to the right of and in the same row as the active cell.

Spreadsheet1.ActiveCell.Offset(0, 1).Select
		




Show:
© 2015 Microsoft