Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
Screen position after hyperlinking | Excel Discussion (Misc queries) | |||
How Do I Autofit To Screen Size | Excel Worksheet Functions | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
Hyperlink Screen Tips not cross platform | Excel Discussion (Misc queries) |