View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
laralea
 
Posts: n/a
Default Hyperlink updates within same worksheet

I have several hyperlinks in Sheet1 to cells within the same worksheet. Is
there a way to update all the hyperlinks at once? I tried Edit Links
update hyperlinks, but that is only working for links to other worksheets.

Example B3 in Sheet1 hyperlinks to DD99 in Sheet1
I need to rename Sheet1 and update all the hyperlinks.

As always - I greatly appreciate this group and the help you give!