O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® by John Green, Rob Bovey, Stephen Bullen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required