Select Method

Select method as it applies to the ChartSpace, ChAxis, ChCategoryLabel, ChChart, ChChartField, ChDataLabel, ChDataLabels, ChErrorBars, ChGridlines, ChLegend, ChLegendEntry, ChPlotArea, ChPoint, ChSeries, ChSurface, ChTitle, ChTrendline, Range, Sheets, Worksheet, and Worksheets objects.

Selects the specified object.


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

Select method as it applies to the PivotTable object.

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.

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

Notify   Optional Boolean. This argument is not supported.


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

Applies to | ChartSpace Object | ChAxis Object | ChCategoryLabel Object | ChChart Object | ChChartField Object | ChDataLabel Object | ChDataLabels Object | ChErrorBars Object | ChGridlines Object | ChLegend Object | ChLegendEntry Object | ChPlotArea Object | ChPoint Object | ChSeries Object | ChSurface Object | ChTitle Object | ChTrendline Object | PivotTable Object | Range Object | Sheets Collection | Worksheet Object | Worksheets Collection Object

See Also | Selection Property | SelectionChange Event | SelectionChanging Event | SelectionType Property