How to make Hyperlink jump accordingly
 

If I had 2 worksheets, whereby sheet1 has hyperlink to sheet2 and vice versa, if I were to add rows randomly to sheet2, all the link reference from sheet1 to sheet2 will be not correct. Is there a way to solver the problem?

How to make Hyperlink jump accordingly
 

Use a named range instead.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"crapit" wrote in message
...
If I had 2 worksheets, whereby sheet1 has hyperlink to sheet2 and vice
versa, if I were to add rows randomly to sheet2, all the link reference from
sheet1 to sheet2 will be not correct. Is there a way to solver the problem?

How to make Hyperlink jump accordingly
 

Another way is to use the =hyperlink() worksheet function.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

crapit wrote:

If I had 2 worksheets, whereby sheet1 has hyperlink to sheet2 and vice versa,
if I were to add rows randomly to sheet2, all the link reference from sheet1
to sheet2 will be not correct. Is there a way to solver the problem?

--

Dave Peterson

How to make Hyperlink jump accordingly
 

What's the limit for name range?
"Anne Troy" wrote in message
news:38a6b$42c6c767$97c5108d$31335@allthenewsgroup s.com...
Use a named range instead.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"crapit" wrote in message
...
If I had 2 worksheets, whereby sheet1 has hyperlink to sheet2 and vice
versa, if I were to add rows randomly to sheet2, all the link reference
from
sheet1 to sheet2 will be not correct. Is there a way to solver the
problem?