About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store


"S. M." writes I am a student. I just failed my Excel Exam. At college, we use Excel 97. The exam was set on Excel 2000. Could you tell me if this is why I failed?"

I could follow your theory if the situation were reversed. But, anything that you know how to do in Excel 97 should have translated directly to Excel 2000. Microsoft is pretty good about making sure that features from one version work in the next version. The one major exception that I can think of is that Excel 97 would run Lotus 1-2-3 macros and Excel 2000 would not. So, unless you solutions to the exam revolved around Lotus Macros, you should have been able to apply Excel 97 knowledge to Excel 2000.

As an aside, for any readers who are sticking with Excel 97 because they have a large supply of Lotus 1-2-3 macros that are still running in Excel 97, Consulting can rewrite those macros in Excel VBA.

By Bill Jelen on 02-Feb-2002 Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.