Wednesday, January 25, 2006

Debugging VBA

From Wills page a link to J-Walks page regarding debugging VBA
John discusses typical errors:

Types of Errors

There are basically three types of errors that can occur:

* Syntax errors:A variety of errors related to entering the code itself. These include incorrectly spelled keywords, mismatched parentheses, and a wide variety of other errors. Excel flags your syntax errors and you can't execute your code until they are correct.
* Run-time errors:
These are the errors that occur while your code is executing. There are many, many types of run-time errors. For example, if your code refers to an object that doesn't exist, you'll get a run-time error. Excel displays a message when there is a run-time error.
* Logical errors:
These are errors that occur through faulty programming. Logical errors may or may not cause a run-time error. In many cases they will simply produce incorrect results.
... and plenty more helpful information there.


Posted by: Jethro | 11:59 PM |