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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.