VisibleRange Property

Applies To

Pane Object, Window Object.

Description

Accessor. 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 is 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"