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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks