Applies To
Arc Object, Arcs Collection, Axis Object, AxisTitle Object, Button Object, Buttons Collection, Chart Object, ChartArea Object, ChartObject Object, ChartObjects Collection, Charts Collection, ChartTitle Object, CheckBox Object, Corners Object, DataLabel Object, DataLabels Collection, DialogFrame Object, DialogSheet Object, DialogSheets Collection, DownBars Object, Drawing Object, DrawingObjects Collection, Drawings Collection, DropDown Object, DropDowns Collection, DropLines Object, EditBox Object, EditBoxes Collection, ErrorBars Object, Floor Object, Gridlines Object, GroupBox Object, GroupBoxes Collection, GroupObject Object, GroupObjects Collection, HiLoLines Object, Label Object, Labels Collection, Legend Object, LegendEntry Object, LegendKey Object, Line Object, Lines Collection, ListBox Object, ListBoxes Collection, Module Object, Modules Collection, OLEObject Object, OLEObjects Collection, OptionButton Object, OptionButtons Collection, Oval Object, Ovals Collection, Picture Object, Pictures Collection, PlotArea Object, Point Object, Range Object, Rectangle Object, Rectangles Collection, ScrollBar Object, ScrollBars Collection, Series Object, SeriesLines Object, Sheets Collection, Spinner Object, Spinners Collection, TextBox Object, TextBoxes Collection, TickLabels Object, Trendline Object, UpBars Object, Walls Object, Worksheet Object, Worksheets Collection.
Description
Selects the object.
Syntax
object.Select(replace)
object
Required. The object to be selected.
replace
Optional (used only with drawing objects and sheets). If True or omitted, the current selection is replaced with a new selection consisting of the specified object. If False, the current selection is extended to include any previously selected objects and the specified object.
Remarks
To select a cell or range of cells, use the Select method. To make a single cell the active cell, use the Activate method.
See Also
Activate Method, Goto Method.
Example
This example selects cells A1:B3 on Sheet1.
Worksheets("Sheet1").Activate
Range("A1:B3").Select