Hyperlinks

[Nikwak]

I have a workbook with only 2 sheets in it. The front sheet has an index for
the second sheet with hyperlinks going to certain sections of the second
sheet. I have set the hyperlinks up using bookmarks but when I add any rows
in the second sheet it throws the hyperlink out and I get sent to the cell
where the bookmark was set up in the first place, before I added the rows.

Is there a way that I can link to the second sheet and not worry about
adding rows and throwing the links out?

Nikwak

 

[Frank Kabel]

Hi
AFAIK this is not possible as you always link to the cell

 

[Dave Peterson]

How about giving that range a name and using that in your hyperlink:

=HYPERLINK("#sheet1!mybkmk","click here")

And it worked ok if I used Insert|Hyperlink.

 

[Nikwak]

Thanks - will try that and see what happens

How about giving that range a name and using that in your hyperlink:

=HYPERLINK("#sheet1!mybkmk","click here")

And it worked ok if I used Insert|Hyperlink.