View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jakobshavn Isbrae Jakobshavn Isbrae is offline
external usenet poster
 
Posts: 78
Default 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