Editing multiple hyperlinks at a time

Hi joakimphooey,

I'd need an example of what you are looking for to give a good answer. That said, does this link help with your question?
https://www.youtube.com/watch?v=5VECmmdtQKE

Hi joakimphooey,

After trying to use the normal Excel Search and Replace, I finally asked Copilot and learned you need some VBA to Search and Replace in the URL/Address of the Hyperlink.
To test this I copied some links to my Column M (see it in the code). I replaced "sheldon" with "parsons" in the URL using the below. NOTE - this search and replace is Case Sensitive.

See if you can understand and/or modify this VBA code to do what you need, now that I understand the problem better.

Please Login or Register  to view this content.

You might want to change the code so it works with the range of data you want instead of Column 13 (Column M) where I tested. If you have a problem please post your workbook so we can give a better answer.

BTW - a few years back I had a large genealogy database that pointed to Ancestry with about 3000 URL links. Ancestry moved the data to another URL. I needed to get the data into GEDCOM and then edit this very large file using a word processor and then suck it back into the Genealogy program. GEDCOM is really readable text and can be treated in a word processor. I understand your pain in trying to fix URLs in Excel. Also - I didn't do this past problem using Excel but I did test the above answer using Excel.

Hello Marvin,

Sorry for taking so long to get back to you. Thanks for the code. I have not had a chance to test it as I am not that well versed in VBA, but will try it in the future. I have found a simple solution using only excel. See attached file. Repair & Replace.xlsx

Thanks for sharing.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.