Position A2 at top-left of window
 

What is the code to write in order to scroll so that cell A2 will appear at
the top-left corner of the window?

Position A2 at top-left of window
 

With ActiveWindow
.ScrollRow = 2
.ScrollColumn = 1
End With

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"hmm" wrote in message
...
What is the code to write in order to scroll so that cell A2 will appear
at
the top-left corner of the window?

Position A2 at top-left of window
 

Try

Application.Goto reference:=Range("A2"), scroll:=True



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)


"hmm" wrote in message
...
What is the code to write in order to scroll so that cell A2 will appear
at
the top-left corner of the window?