Hyperlink Renaming

Thanks for the post,

I tried it out and I seem to be getting an error when i run it saying compile error variable not defined and it then highlights the word "clear"
but on the upper left hand side it has a left arrow pointing to a colored row that has the text Sub AddHyperlinks()

thanks