TopRow Property

The TopRow property returns or sets the first visible worksheet row in the window. Returns a Long.

Syntax

object.TopRow

object.TopRow = Row

 

Parameter	Type	Description
Row	Long	required, row number

 

Example 1

This example demonstrates how to return the first row visible in a worksheet window.

Debug.Print WksWindow.

Example 2

This example demonstrates how to set the second row as the first visible row in a worksheet window.

WksWindow.TopRow(2)

 

Used by: AutoWksWindow object