Scrolling in a macro

[cstimart]

OK, so I have a growing list of data on Sheet(1), currently 280+ rows and growing. Daily, I utilize a macro that goes thru the data and prompts for user input on various rows. The top row is frozen, so the column headers are visible.

Is there a relatively easy way to have the row that is waiting for user input to scroll to the top, under the frozen row? I think scrolling the first instance is pretty simple, but the subsequent one(s) seem to be problematic.

Any ideas?

 

[VoG]

Try

Sub Scrl()

Application.Goto Range("A" & Rows.Count).End(xlUp), True

End Sub

 

[Andrew Poulsom]

To go to A70 on the active sheet and scroll the window:

Sub Test()
    Application.Goto Reference:=Range("A70"), Scroll:=True
End Sub