IN THIS CHAPTER
Working with ranges in your VBA code
Changing Boolean and non-Boolean settings
Manipulating charts with VBA
Making your VBA code run as fast as possible
A good example often communicates a concept much better than a lengthy description of the underlying theory. In that spirit, this chapter presents several examples that demonstrate common VBA techniques.
These examples are organized into the following categories:
Although you may be able to use some of the examples directly, in most cases you must adapt them to your own needs.
Most of your VBA programming probably involves worksheet ranges. (For some background on Range objects, refer to Chapter 8.) When you work with Range objects, keep the following points in mind: