Edit

Pane.VisibleRange property (Excel)

  • Article

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 Pane object.

Example

This example displays the number of cells visible on Sheet1.

Worksheets("Sheet1").Activate 
MsgBox "There are " & Windows(1).VisibleRange.Cells.Count _ 
 & " cells visible"

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.