MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Differences from older versions of EXCEL/VBA

  Asked By: Leona    Date: Nov 18    Category: MS Office    Views: 1446

Does anyone maintain a list of differences between various versions
of EXCEL? For example, is there a list of VBA functions in Excel
2003 that won't work on Excel 97?

At the request of a couple of users, I just took an application of
mine and made it work in Excel 97. Here are three of the things I
had to do:

1. Excel 97 does not have the ROUND() function in VBA. I replaced
ROUND() with INT(), and looked at the remainder to see whether I
needed to round up.

2. I use a button to create a COMMENT on a sheet. The COMMENT
overlaps a chart. The default in Excel 97 seems to be that the
chart covers the COMMENT. (the default in later versions seems to
be that the COMMENT covers the chart.) I had to explicitly move the
COMMENT to the front.

3. Excel 97 doesn't allow several of the PasteSpecial options. I
had to use simpler choices and then adjust.

If there is a maintained list anywhere, I'd be glad to contribute to



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Differences from older versions of EXCEL/VBA Or get search suggestion and latest updates.