I have not tried to write a procedure to do what you are asking, but I
have used the search & replace from within the spreadsheet to replace
everything matching the search criteria.

I don't know if any of your hyperlinks have an apostrophe in the
address itself. Wouldn't seem likely?

Make a backup copy before your do try this.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=501234