ActiveCell Property
The ActiveCell property returns or sets the worksheet active cell location. Returns a WksRange object.
Syntax
object.ActiveCell
object.ActiveCell = Cell
Parameter | Type | Description |
Cell | Variant | required, see below and Specifying Cell Coordinates |
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: AutoWksWindow object