Chapter 2. Make a Macro Do Complex Tasks

Chapter at a Glance

image with no caption

In this chapter, you will learn to:

  • Break a complex project into manageable pieces.

  • Watch a macro run one statement at a time.

  • Enter values into a macro while it’s running.

  • Record movements relative to the active cell.

  • Create a macro that runs other macros.

Rube Goldberg was famous for inventing intricate contraptions with hundreds of parts that made what should have been a simple device appear wildly complex. For example, his cat “alarm clock” drops a ball into a bucket and the weight of the bucket lifts a lever that releases a spring that wakes up a cat. The Milton Bradley game company has ...

Get Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step 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.