How to make Hyperlink jump accordingly

[crapit]

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?

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"crapit" <[email protected]> wrote in message
news:[email protected]...
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]

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),sheetone!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

[crapit]

What's the limit for name range?
"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> Use a named range instead.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "crapit" <[email protected]> wrote in message
> news:[email protected]...
> 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?
>
>