Applies To
Application Object, Window Object.
Description
Accessor. Returns a Range object that represents the active cell in the active window (the window on top) or in the specified window. If the window is not displaying a worksheet, this property fails. Read-only.
Remarks
If you do not specify an object qualifier, this property returns the active cell in the active window.
Be careful to distinguish between the active cell and the selection. The active cell is a single cell inside the current selection. The selection may contain more than one cell, but only one is the active cell.
The following expressions all return the active cell, and are all equivalent.
ActiveCell Application.ActiveCell ActiveWindow.ActiveCell Application.ActiveWindow.ActiveCell
Example
This example uses a message box to display the value in the active cell. Because the ActiveCell property will fail if the active sheet is not a worksheet, the example activates Sheet1 before using the ActiveCell property.
Worksheets("Sheet1").Activate MsgBox ActiveCell.Value
This example changes font formatting for the active cell.
Worksheets("Sheet1").Activate With ActiveCell.Font .Bold = True .Italic = True End With