Excel 2019 Power Programming with VBA

CHAPTER 7VBA Programming Examples and Techniques

IN THIS CHAPTER

• Using VBA to work with ranges
• Using VBA to work with workbooks and sheets
• Creating custom functions for use in your VBA procedures and in worksheet formulas
• Trying miscellaneous VBA tricks and techniques
• Using Windows application programming interface (API) functions

Learning by Example

Most beginning VBA programmers benefit from hands-on examples. A well-thought-out example usually communicates a concept much better than a description of the underlying theory. Therefore, instead of taking you through a painful review of every nuance of VBA, this chapter guides you through demonstrations of useful Excel programming techniques.

Here, you will walk through examples that solve practical problems while furthering your knowledge of VBA. This includes the following:

• Working with ranges
• Working with workbooks and sheets
• VBA techniques
• Functions that are useful in your VBA procedures
• Functions that you can use in worksheet formulas
• Windows API calls

Subsequent chapters in this book present additional feature-specific examples: charts, pivot tables, events, UserForms, and so on.

Working with Ranges

The examples in this section demonstrate how to manipulate worksheet ranges with VBA.

Specifically, we provide examples of copying a range, moving a range, selecting a range, identifying types of information ...