Show unhidden row right at the top of page (not half way down!?)

Hello Everyone,
I am not sure why but when I run the below macro the newly revealed
range is not displaying at the very top of the sheet?
It is displaying half way down the sheet. Does anyone know why or a way that I am
able to ensure that when this macro is run the selected cell
("498") is right at the top of the page? I have tried a few things
but am unable to get it at the top! I am trying to reveal every
row on the page and then put row #498 right at the top of the page.
Macro is triggered by a button as is as follows:

Sub RevealAlternativeGWB()
Cells.Select
Selection.EntireRow.Hidden = False
Range("F498").Select
End Sub



Thank you for any help,

Margate

Please Login or Register  to view this content.