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

VII. Programming Excel > 25. Automating Tasks with Macros

Chapter 25. Automating Tasks with Macros

No one wants to repeat the same task over and over again. Excel gurus especially hate the drudgery of repetitious work like data entry and formatting cell after cell after cell. Fortunately, Excel offers a serious time-saving tool called macros, which are miniature programs that automatically perform a series of steps within any workbook.

Excel macros are written in a full-blown programming language called VBA (short for Visual Basic for Applications). VBA is a scaled-down version of the incredibly popular Visual Basic programming language, and it’s fined-tuned for Excel and other Office applications. Fortunately, you don’t need to be a programmer to use VBA. In fact, you can create a simple macro using a special Excel tool called the macro recorder. The macro recorder works like a tape recorder, but instead of recording audio, it records keystrokes and mouse actions as you perform them.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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