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