• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Building More Powerful Works... > Understanding How Macros Automate Yo...

Understanding How Macros Automate Your Work

To complete many tasks in Excel, you need to execute a series of commands and actions. To print two copies of a selected range of Sheet2 of a worksheet, for example, you need to open the workbook, switch to Sheet2, select the print area, open the Print dialog box, and specify that you want to print two copies. If you often need to complete the same task, you'll find yourself repeatedly taking the same series of steps. It can be tiresome to continually repeat the same commands and actions when you can easily create a mini-program, or macro, that accomplishes all of them with a single command.

Creating a macro is easy and requires no programming knowledge on your part. Excel simply records the steps you want included in the macro while you use the keyboard and mouse. When you record a macro, Excel stores the list of commands with any name you choose. You can store your macros in the current workbook, in a new workbook, or in Excel's Personal Macro workbook. Storing your macros in the Personal Macro workbook makes the macros available to you from any location in Excel, even when no workbook is open.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint