Pro Excel 2007 VBA

CHAPTER 7Debugging and Error Handling

Debugging technique is an often overlooked part of a developer's set of skills. In this chapter, we are going to explore some debugging techniques that will save you time when troubleshooting your code, and make you a more efficient coder.

Error handling is another area in which we often find ourselves taking shortcuts. We will also look at error handling methods in this chapter, and we'll see how to deliver user-friendly messages to our users.

Debugging

Debugging is the process of stepping through code to find inconsistencies due to coding errors when output is not what you expected, or to find the cause of errors at runtime.

Here are some examples of output not displaying what's expected:

• When reading ...