View Single Post
  #3   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

And names shouldn't mess up--if they're still valid after you do your deletes
and moves...

But if you're working with names, get Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It might make finding problems easier.

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