VisibleRange Property
Applies To
Pane object, Window object.
Description
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.
Example
This example displays the number of cells visible on Sheet1.
Worksheets("Sheet1").Activate
MsgBox "There are " & Windows(1).VisibleRange.Cells.Count _
& " cells visible"