Is it possible to use 'Replace All' function in hyperlinks

[prabhat_79_in]

In Excel is it possible to use 'Replace All' function in hyperlinks
Normally, if you do a replace all in excel, it replaces the contents o
the cells but not the hyper links. I want to change one particular wor
in around 100 hyperlinks in one particular master file. Pls use you
sources and advise.

Somehow i need to modify the hyperlink text in all the hundred o
them.
If there is any VB code that i can run in Visual basic Editor for doin
this than please provide it.:

 

[Dave Peterson]

If you used the worksheet function =hyperlink(), then edit|replace will work
nicely!

But I bet you used insert|hyperlink.

Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm