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 Specifying Cell Coordinates |
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