Excel2000 and Excel 97 VBA CODE

[mdighe]

I have written some code in Excel 2000 but need to run the same macro on a machine with Excel 97. I do not have the option of upgrading 97 to 2000. Is there a list available that tells me the commands new in excel2000? I could use such a tool to make sure that the macro is excel97 compliant.

thanks

 

[joerd]

You can look in the Excel 2000 bible, by John Walkenbach, at Amazon.
Search inside the book for What's new and you'll see that there are some new features, mainly in the interface, so they shouldn't affect your macros.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.