Sheet View Position

[Brian Matlack]

Hi!
What code do I use to ensure that when I go to a new sheet and select
cell A1 that cell A1 is in the upper left corner of my screen?
Thanks!!

 

[Tom Ogilvy]

Appliction.GoTo Reference:=worksheets("Sheet3").Range("A1"),Scroll:=True

--
Regards,
Tom Ogilvy


"Brian Matlack" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

One possible method:

Application.Goto Range("A1"), Scroll:=True

HTH

 

[Brian Matlack]

Works Great!! Thanks!!