Chapter 3. Excel and VBA Development Best Practices

This chapter appears early in the book because we want you to understand why we are doing certain things the way we are in later chapters. Unfortunately, this also means we must cover a few topics in this chapter that do not get full coverage until later. For best results, you might want to review this chapter after you have read the rest of the book.

As you read this chapter, keep in mind that even though the practices described here are generally accepted best practices, there will always be certain cases where the best thing to do is not follow the best practice. We try to point out the most common examples of this here and in the best practices discussions in the chapters that follow.

Naming ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.