Chapter 27. Working with Macros

Macro Basics

A macro is a small program that carries out the result of a set of keystrokes and mouse clicks. Under ordinary conditions, you could simply perform the keystrokes and mouse clicks and never think about macros. However, macros become useful when the keystrokes and mouse clicks you need to perform are repetitive. When you find yourself repeating a set of keystrokes and mouse clicks in a worksheet or chart, you should consider creating a macro.

Do not let the word "program" intimidate you. You can record a macro very easily. Excel's macro feature captures your keystrokes and mouse clicks as you make them and then enables you to save the results of those keystrokes and mouse clicks. Then, you can run the ...

Get Master VISUALLY® Excel® 2010 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.