I recorded a macro on Excel 2007. I needed to remove condiditional formats
and then add a different one. When I looked at the code it added several
lines with "FormatConditions". This code works good on Excel 2007 but
several of our computers run Excel 2003 or even Excel 1997. When these older
versions run this code it gets and "object not supported" error. Is there an
easy way to alter the code or am I going to have to record it in one of the
older versions?
--
Thanks
Shawn