View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Maintaining in-doc hyperlinks when rows/cells change

I think using Names is the safest.

But if you're using the =hyperlink() worksheet function, you could make sure
that both workbooks are open when you make changes. Since it's just a formula,
excel will adjust them when you make changes.



Ittai Gilat wrote:

Suppose I want to hyperlink a row in another worksheet. I tried using names,
but they get messed up after rows are added/moved/deleted. Is there a way to
get sticky names that move with a row/column/cell?


--

Dave Peterson