Sub ScrollMyCell()
ActiveWindow.ScrollRow = Range("MyCell").Row
ActiveWindow.ScrollColumn = Range("MyCell").Column

End Sub

"James" wrote:

Hello NG,
I'e been using Excel for a while but I'm new to Named Ranges.
I have a column of hyperlinks, on a master page, to cells I've named on
indiuidual pages.
example on the sheet for Smith in cell A2 I call it Smith_Week_1
and again on Smith in Cell A18 I call it Smith_Week_2.
and so forth down the page for about 20 different cells.
I do this for 9 employees.
Depending on where the worksheet was last closed the named cell will be in
the middle of the page or at the top or at the bottom.
Is there a way to always make the named cell be in the top left cornor?
Thanks for any help
--
James