I'm trying to write a macro that will work in Excel 2002 and Excel 2007. But sometimes I would like to take advantage of the 2007 commands that won't work in 2002.
I know about the compiler directives #IF ... #ELSE ... #END IF, but I can't find a constant that can tell the difference between the 2 versions.
How can I write code that takes advantage of the 2007 language, but won't crash the 2002 compiler?
Bookmarks