Removing Hyperlink
 

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?
--
Thanks
Shawn

Use Clearcontents instead of Clear
"Shawn" wrote in message
...
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?
--
Thanks
Shawn

Hi Shawn,

Selection.Hyperlinks.Delete
more information in: http://www.mvps.org/dmcritchie/excel...#DelHyperlinks ---HTH, David McRitchie, Microsoft MVP -
Excel [site changed Nov. 2001]My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page:
http://www.mvps.org/dmcritchie/excel/search.htm "Shawn" wrote in message
...
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?
--
Thanks
Shawn