Address of first visible cell
Perfect - thank you very much.
--
jake
"Norman Jones" wrote:
Hi Jake,
Try:
'=============
Public Sub Tester()
Dim Rng As Range
Set Rng = ActiveWindow.VisibleRange.Cells(1)
MsgBox Rng.Address
End Sub
'<<=============
---
Regards,
Norman
"Jakobshavn Isbrae" wrote in
message ...
How can I determine the address of the first visible cell in the active
worksheet?
That is the cell in the top, left-hand, corner that is visible in the
worksheet's current, scrolled, state?
Thanks for any help or suggestions
--
jake
|