Macro to update hyperlinks?

F

FJ

Hi, I have an Excel file that has many hyperlinks linking to cells on other
sheets all within the same file. I created the hyperlinks by using defined
ranges and then going to Insert, Hyperlink, and choosing the item from the
"Defined Names" list.

This works great until the data is sorted. Then the hyperlinks point to the
cell where the item was originally instead of to the new location.

It's interesting because inserting and deleting rows doesn't seem to matter.
It's only when the data is sorted. Is there a macro or anything that would
update the hyperlinks and make them point to their new location?

Thanks in advance for any information.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top