Returns a Pane object that represents the active spreadsheet pane. Read-only.
expression.ActivePane
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"