Recording a scrolling macro

[georgedixon]

Hi,
I have been working on a really big spreadsheet, on the first page it is split into several different sections, i have recorded macros to allow me to scroll quickly between sections via the use of a button. These however scroll a certain amount of cells relative to the position of the top cell when the button is pressed. Using this code:

ActiveWindow.SmallScroll Down:=154

I was just wondering if there were a way to make it scroll to an 'absolute' position, i.e. so that a certain row will always be at the top when pressed.
Any help is appreciated, Thanks

[georgedixon]

Solved it myself haha, with the following:

Application.GoTo Sheets(1).Range("CELL REF"), True