I'm trying to update the hyperlinks in a sheet. I had 4 sheets of data which I combined into one. I need to update all hyperlinks i created with the new cell numbers on the same sheet. Sheet 1 had hyperlinks to sheet 3 and 4. After combining the sheets, I have all the data in one sheet. Not only the sheet name, the cell references have also changed. Can anyone help?
It sounds as if all you need to do is to delete the existing hyperlink and replace it with one that points to the new location. But maybe I'm missing something? Let me know if I can help further.
Regards
Alastair
Sounds like you have completely broken the initial hyperlinks. You will be better off deleting them and starting again
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks