screen position indication?
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. |
screen position indication?
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 |
All times are GMT +1. The time now is 10:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com