Range.Activate 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.

Activates a single cell, which must be inside the current selection. To select a range of cells, use the Select method.

expression .Activate

expression A variable that represents a Range object.

Return Value

Variant

This example selects cells A1:C3 on Sheet1 and then makes cell B2 the active cell.

Worksheets("Sheet1").Activate 
Range("A1:C3").Select 
Range("B2").Activate

Concepts

Other resources

Show: