I am creating Excel sheets that are used on computers running different
versions (2000 onwards) of Excel and different language versions. Using
Excel 2003 for creating the sheets and recording/modifying the VBA
code, I get results that work perfectly well when I test them on Excel
2003.

However, some of the macros generate errors when run on other Excel
versions? Is there a way to know, without sending the files for a
trials to the users and without having access to all previous versions
for testing, to know the common denominator scripts that work on Excel
2000 onwards.

My problems are mainly with
- Hide/Unhide sheets
- Paste Special Values
- Sorting