Range.Activate Method (Excel)
Activates a single cell, which must be inside the current selection. To select a range of cells, use the Select method.
Syntax
expression .Activate
expression A variable that represents a Range object.
Return Value
Variant
Example
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