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

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

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