Scrolling a row to the top of the active screen

[tim_robertson1234]

Is there a way to scroll the active row to the top of the
screen, maybe using the show method?

Can this be done using columns? Any help would be
appreciated.

 

[Don Guillett]

Here is a way that may be modified to suit your needs.
Or, you could use send keys for control home

Sub gototop()
Application.GoTo Reference:=Range("A7"), Scroll:=True
End Sub

 

[David McRitchie]

Hi Tim,
Repositioning screen and/or active cell (#TopLeft)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#topleft