Window.VisibleRange Property (Excel)
Returns a Range object that represents the range of cells that are visible in the window or pane. If a column or row is partially visible, it's included in the range. Read-only.
Syntax
expression .VisibleRange
expression A variable that represents a Window object.