ActiveCell Property

ActiveCell returns or sets the active cell location. Returns a WksRange object.

Syntax

object.ActiveCell

object. ActiveCell = Cell

Parameter	Type	Description
Cell	Variant	required

Remarks

The ActiveCell is a one-cell range that refers to the location of the active cell in a worksheet window. The cell is specified as a range object, as a range string ("A1:B5"), or as a cell coordinate string ("A5"). The bottom-right coordinate is ignored if a range is specified.

Example 1

This example demonstrates how to return the active cell.

Debug .Print WksWindow.ActiveCell

Example 2

This example demonstrates how to set cell A5 as the active cell.

WksWindow.ActiveCell = "A5"

Used by: WksWindow object