Skip to main content

Worksheet.Activate method

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

Makes the current sheet the active sheet.

Syntax

expression.Activate

expression A variable that represents a Worksheet object.

Remarks

Calling this method is equivalent to choosing the sheet's tab.

Example

This example activates Sheet1.

Worksheets("Sheet1").Activate

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>