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.Select
*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
| PivotScrollTypeEnum can be one of these PivotScrollTypeEnum constants. |
| plScrollTypeAll |
| plScrollTypeBottom |
| plScrollTypeLeft |
| plScrollTypeNonedefault |
| 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
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