What is the code to write in order to scroll so that cell A2 will appear at
the top-left corner of the 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?

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?