Chapter 14
Bug Extermination Techniques
IN THIS CHAPTER
Defining a bug and knowing why you should squash it
Recognizing the types of bugs you might encounter
Using techniques for debugging your code
Using the Visual Basic Editor’s built-in debugging tools
Presenting a handy list of bug reduction tips
If the term bug conjures up an image of a creepy-crawly, this chapter can set you straight. Simply put, a bug is an error in your programming. This chapter details programming bugs — how to identify them and how to wipe them off your module.
Species of Bugs
In programming, the term bug, as you probably know, refers to a software problem. In other words, if software doesn’t perform as expected, it has a bug. Fact is, all major software programs have bugs — lots of bugs. Excel itself has hundreds (if not thousands) of bugs. Fortunately, the vast majority of these bugs are relatively obscure and appear in only very specific circumstances.
When you write large enough VBA programs, your ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access