Removing Hyperlink

[Guest]

I recorded a macro where I remove a Hyperlink. I am using that code in a
larger program. The problem is, this code removes all the cell formatting,
not just the hyperlink. How can I remove the hyperlink, by code, without
removing other cell formatting?

 

[Bob Umlas]

Use Clearcontents instead of Clear

 

[David McRitchie]

Hi Shawn,

Selection.Hyperlinks.Delete
more information in: http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks ---HTH, David McRitchie, Microsoft MVP -
Excel [site changed Nov. 2001]My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: