Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

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?

Re: ipertext link

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.