finding the row number at the top of the screen?

[merlin777]

I need to know what row number is at the top of the screen. Is there something like ROW() I an use for this?

To be precise, I have frozen the top 6 rows so I actually want to know the row number that currently occupies the 7th row from the top of the screen, or the first row after the frozen rows.

 

[Momentman]

like this maybe

Sub findaddrss()
   MsgBox ActiveWindow.SplitRow + 1
End Sub

 

[Rick Rothstein]

I need to know what row number is at the top of the screen. Is there something like ROW() I an use for this?

To be precise, I have frozen the top 6 rows so I actually want to know the row number that currently occupies the 7th row from the top of the screen, or the first row after the frozen rows.

This is a VBA question, correct? If so, give this a try...

TopMoveableRow = ActiveWindow.VisibleRange.Row

 

[merlin777]

thanks, guys.