Hyperlinking Cells

[BryanC]

Hello,

I am hyperlinking text boxes in one sheet to certain cells in another sheet
of the same workbook. However, when I add a row before the cells, the text
boxes' hyperlinks do not shift down one letter but rather remain unchanged.

For example, I have a text box link to D9, and I insert a row between rows B
and C, which would make the cell I'm interested in to switch from D9 to E9.
However, the link remains to link to D9.

How can I fix this? Thanks.

 

[Gary''s Student]

Maybe its how you are setting the link. Put a Textbox in the sheet and click
on it to make it Selected. Then click in the formula bar and enter:
=D9
and then click elsewhere.

The contents of D9 should appear in the Textbox. If you insert rows above
D9 or columns to the left of D9 the formula will adjust.

 

[BryanC]

Your method makes the textbox contents accurate -- which is good. However, I
would also like the hyperlink to update itself as well if there are rows
inserted or deleted before it.

 

[Bamos101]

Bryan, your situation can be fixed using Data Range Names (even for a single
cell that you are linking to). Once you create a data range name, and link
to that name, you will be good to go, no matter if you add text boxes, insert
rows or columns.