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 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