Select Method

Microsoft Excel Visual Basic

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.

ShowSelect 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.

ShowSelect 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.

ShowSelect 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