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" <(E-Mail Removed)> wrote in
message news:64A0C725-2E11-44BA-8235-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
> message news:64A0C725-2E11-44BA-8235-(E-Mail Removed)...
> > 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
>
>
>