The title pretty much sums it up I guess. I need some step by step help please on how to create a macro that scans my entire worksheet and changes the hyperlink paths to point somewhere else and then how to run the macro (only needs to be done once, a server just moved.)
Something like changing c:\oldpath to c:\morecomplicated\newpath.
We are using Excel2010. I just don't use excel much in terms of macros, etc, so need a little extra help please.