Conditional formatting in Xl 2010 vs. earlier versions

[abousetta]

Hi,

I normally use Option Explicit at the begining of all my code, but found one instance that is troubling me. Part of a macro performes conditional formatting. Depending on the version of Excel you have, I have set up two scenarios: one for XL 2010 and one for XL 2007. The problem is that it will not compile in a machine that runs XL 2007 if I have Option Explicit added to the top of my code because it doesn't recognize the variables that MS introduced with the newer version of XL. I tried declaring them as variants but to no avail.

Any thought?

Please Login or Register  to view this content.

abousetta

[abousetta]

Any thoughts?

[abousetta]

A small bump.