if you start by coping the cell format, you will get the wrong format
because it will be blue and underlined. So you have to copy the existing
format, make changes to the Font, Size, & Color first. Then remove the
Hyperlink, then copy the NEW format as changed. This is what I need to do.

I can't get anything to accept the vFontName as "Trebuchet MS"
Thanks

"CellShocked" wrote in message
...

On Mon, 25 Feb 2013 14:44:09 -0600, "JCO" wrote:

That does seen simpler, however, it is not removing the hyperlink. It
simply sets the hyperlink to null.
It still looks and acts like a hyperlink. I guess I need to change the
font
color and take off the underline, however how do I stop the mouse-over from
still reacting to it as a hyperlink (mouse changes and the balloon shows
the
null link).


Copy and paste the entire column/row, and only paste the formats.

Clear the hyperlinks, then paste the formats back to the original
column/row.