Select Method
Select method as it applies to the ChartObject, ChartObjects, OLEObject, and OLEObjects objects.
Selects the object.
expression.Select(Replace)
expression Required. An expression that returns one of the above objects.
Replace Optional Variant. 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.
Select method as it applies to the DataTable and LeaderLines objects.
Selects the object.
expression.Select
expression Required. An expression that returns one of the above objects.
Selects the object.
expression.Select(Replace)
expression Required. An expression that returns one of the above objects.
Replace Optional Variant. The object to replace.
Select method as it applies to
all other objects in the Applies To list.
Selects the object.
expression.Select
expression Required. An expression that returns all other objects in the Applies To list.
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.
Example
This example selects cells A1:B3 on Sheet1.
Worksheets("Sheet1").Activate
Range("A1:B3").Select