ActivePane Property

Returns a Pane object that represents the active spreadsheet pane. Read-only.

expression   Required. An expression that returns a Window object.

Example

This example sets the value of the cell in the upper-left corner of the visible range in the active pane on the spreadsheet.

Spreadsheet1.ActivePane.VisibleRange.Cells(1, 1).Value = "top left"