Backward Capability of Excel Macros

[Ken]

I've written some simple marco for Excel 2002 spread sheet
that causes a "1004 run time error" when running on Excel
2000. Is there a good way to make macros backward capable
to earlier version....?

 

[Don Guillett]

As usual, post your code for comments. Of course, if you have xl2000, you
should write it there to be sure. A simple macro should not pose a problem.

 

[Dave Peterson]

Test the heck out of them on xl2k.

Or write them in xl2k (or the oldest version of excel that will be using them).