VisibleRange Property [Excel 2003 VBA Language Reference]

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"

Applies to | Pane Object | Window Object