101 Ready-to-Use Excel Macros

  • 3h 43m
  • John Walkenbach, Michael Alexander
  • John Wiley & Sons (US)
  • 2012

Save time and be more productive with this helpful guide to Excel macros!

While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use.

  • Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge
  • Outlines a problem that needs to be solved and provides the actual Excel macro, as well as the downloadable code, to solve the problem
  • Provides an explanation of how each macro works and where to use the macro

With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive.

About the Authors

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community.

John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona.

In this Book

  • Introduction
  • Getting Started with Excel Macros
  • Working with Workbooks
  • Automating Worksheet Tasks with Macros
  • Selecting and Modifying Ranges
  • Working with Data
  • Working with PivotTables
  • Manipulating Charts with Macros
  • E-Mailing from Excel
  • Integrating Excel and Other Office Applications