O'Reilly logo

Excel® 2007 Bible by John Walkenbach

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 44. VBA Examples

<feature><title>In This Chapter</title> </feature>

My philosophy about learning to write Excel macros places heavy emphasis on examples. I’ve found that a well-thought-out example often communicates a concept much better than a lengthy description of the underlying theory. In this book, space limitations don’t allow describing every nuance of VBA, so I’ve prepared many examples. Don’t overlook VBA’s Help system for specific details. To get help while working in the VB Editor window, press F1 or type your search terms into the Type A Question For Help box in the menu bar.

This chapter consists of several examples that demonstrate common VBA techniques. You may be able to use some examples directly, but in most cases, you must adapt them to your own needs. These examples are organized into the following categories:

  • Working with ranges

  • Working with workbooks

  • Working with charts

  • Programming techniques to speed up your VBA code

Working with Ranges

Most of what you do in VBA probably involves worksheet ranges. When you work with range objects, keep the following points in mind:

  • Your VBA code doesn’t need to select a range to do something with the range.

  • If your code does select a range, its worksheet must be active.

  • The macro recorder doesn’t always generate the most efficient code. Often, you can use the recorder to create your macro and then edit the code to make it more efficient.

  • I recommend that ...

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