Pitfalls of Earlier versions of Excel

[austenr]

I know there are some differences when writing macros for earlier versions the sort being one of them wher later version inclusons cause problems. I find I have to create a lot of macros for people using 97. Can anyone tell me some of the other considerations when creating for earlier versions? Thanks

[Zack Barresse]

VBA syntax. Especially in Calculation and AutoFilter. Those are my two biggest bugs. :)

[Bob Phillips]

Develop under 97 and you won't get any problems. Excel is backwards compatible like any good product should be.

[Glaswegian]

One thing I always remember in 97 is that Worksheet Change Events won't fire from data validation.

See here http://support.microsoft.com/default.aspx?scid=kb;en-us;172832

Regards