Select Method

Applies To

Axis object, AxisTitle object, Chart object, ChartArea object, ChartObject object, ChartObjects collection object, Charts collection object, ChartTitle object, Corners object, DataLabel object, DataLabels collection object, DataTable object, DownBars object, DropLines object, ErrorBars object, Floor object, Gridlines object, HiLoLines object, LeaderLines object, Legend object, LegendEntry object, LegendKey object, OLEObject object, OLEObjects collection object, PlotArea object, Point object, Range object, Series object, SeriesLines object, Shape object, ShapeRange collection object, Sheets collection object, TickLabels object, Trendline object, UpBars object, Walls object, Worksheet object, Worksheets collection object.

Description

Selects the object.

Syntax

expression.Select(Replace)

expression Required. An expression that returns an object in the Applies To list.

Replace Optional Variant (used only with sheets). True to replace the current selection with the specified object. False to extend the current selection to include any previously selected objects and the specified object.

Remarks

To select a cell or a range of cells, use the Select method. To make a single cell the active cell, use the Activate method.