MrExcel Publishing
Your One Stop for Excel Tips & Solutions

ipertext link


Posted by Giuseppe on February 01, 2002 9:13 AM

I'm trying to use ipertext link to move quickly to specific cell in the same datasheet (excel 2000)
It seems that sometimes the cell i referred the link to remains at the top of the screen.
sometimes at the bottom.
Is there any other way to get better results?


Posted by Chris D on February 02, 2002 4:18 PM

maybe rather than hyperlinking to a specific cell, try hyperlinking to a named range, where the first cell of that range is your hyperlink target

make the range as deep as your screen, so it has to fit it all in when you go to it, thus your target cell is always at the top of the screen...

any help ?
Chris