Export (0) Print
Expand All

Range.Activate Method

Office 2007
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.

Visual Basic for Applications
Worksheets("Sheet1").Activate
Range("A1:C3").Select
Range("B2").Activate



Community Additions

ADD
Show:
© 2014 Microsoft