Selected cell position

[ledzepe]

I've a long spreadsheet about 1000 rows long divided into 10 categories. I frozed the top 5 rows and placed 10 buttons so that the users can go directly to the category they want to go. I've used the macro below:

Please Login or Register  to view this content.

When I press the button, the active cell is always displayed in the middle of the excel window. Is there a way to force the active cell to be directly underneath the frozen row. Basically I want row 500 directly under row 5 when I hit the category 5 button.

[shg]

Maybe like this:

Please Login or Register  to view this content.

[ledzepe]

Perfect!!!!