Skip to main content

Worksheet.Select method

Table of contents
  1. Syntax
  2. Parameters
  3. Remarks

Selects the object.


expression.Select (Replace)

expression A variable that represents a Worksheet object.


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 multiple sheets, use the Select method. To make a single sheet the active sheet, use the Activate method.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>