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

Chapter 31. Recording and Editing a Macro > Macros to Help You Work Faster

Macros to Help You Work Faster

This section provides some helpful suggestions for macros that can speed up your work. Be sure to store them in the Personal Macro Workbook so that they'll be available for playback in all your workbooks. Consider assigning each a keyboard shortcut or toolbar button for faster playback.

  • Print the current region— This macro selects all the cells in the current region and prints them. The current region is defined as a range of contiguous cells bounded by blank columns and blank rows (or positioned at the edge of the worksheet). When recording this macro, choose Edit, Go To, click the Special button, and select Current Region to select the current region.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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