Worksheet.Select Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Selects the object.

expression .Select(Replace)

expression A variable that represents a Worksheet object.

Parameters

Name

Required/Optional

Data Type

Description

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.

To select a sheet or a multiple sheets, use the Select method. To make a single sheet the active sheet, use the Activate method.

Show: