View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave K Dave K is offline
external usenet poster
 
Posts: 16
Default Hyperlink to a Particular Cell ---- but allowing flexibility to add new rows and still keep the link

Hello all,
I am trying to create a hyperlink to a cell in a spreadsheet (i.e.,
"to a place in this document"). However, when I add new rows, the
hyperlink does not change to stay with the cell that I originally
created the hyperlink to.

Is there a way to create a hyperlink to a cell that will stay with
that cell even when new rows or columns are added?

Thanks for any help!

(For example, I created a hyperlink in cell A3 that links to cell A12
that contained the word "Supplies". However, when I add new rows to
the worksheet, the cell containing the word "supplies" is no longer in
cell A12, as it has moved down however many rows that I have added.)