title: Editing Hyperlinks Excel 2010 Macro
body: <p>Ok so I want to create a macro to replace a part of a hyperlink. I have tons of hyperlinks in the excel file. Is there a way to create a macro to do this.</p>
  
  <hr>
  
  <p>For example</p>
  
  <ul>
  <li><p>www.OldName.com/</p></li>
  <li><p>www.Oldname.com/a/ </p></li>
  <li><p>www.Oldname.com/b/</p></li>
  </ul>
  
  <hr>
  
  <p>to </p>
  
  <ul>
  <li><p>www.NewName.com/</p></li>
  <li><p>www.NewName.com/a/</p></li>
  <li><p>www.Newname.com/b/</p></li>
  </ul>