Select Method

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

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.

Select method as it applies to the Chart, Charts, Shape, ShapeRange, Sheets, Worksheet, and Worksheets 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