Like:

Option Explicit
Sub testme()

Dim myVRng As Range
Set myVRng = ActiveWindow.VisibleRange

With myVRng
MsgBox .Address & vbLf & .Row & vbLf & .Cells(.Cells.Count).Row
End With

End Sub

But I'm not sure I've ever depended on what the activewindow was looking at.

If you're looking for the row of the activecell, you can use
activecell.row



nastech wrote:

is there a way to identify the location of where your screen is scrolled to? /
top / bottom of view. thanks

looking for a way to find a row number for formula's.

--

Dave Peterson