Excel 2007 Macros Made Easy

by Gail Perry

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Get beyond the basics with Excel 2007 macros

Now you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. You'll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity.

• Record and edit macros
  
• Create and debug macros in VBA
  
• Save macros to the Personal Macro Workbook or other workbooks
  
• Create VBA subroutines and functions
  
• Develop interactive macros
  
• Format cells using macros
  
• Create variables and arrays
  
• Apply logic to macros with If/Then/Else routines
  
• Use loops to process data
  
• Add controls to your worksheets
  

Product Details

ISBN-13:	9780071599580
Publisher:	McGraw Hill LLC
Publication date:	10/27/2008
Edition description:	List
Pages:	208
Product dimensions:	7.90(w) x 7.90(h) x 0.50(d)

About the Author

Gail Perry is a CPA, financial journalist, the author more than 20 books on financial software, taxes, and personal finance. She is the managing editor for AccountingWEB, a contributing editor for SMBFinance magazine, and an instructor.

Table of Contents

Introduction
Chapter 1. Recording Macros
Chapter 2. Editing Macros
Chapter 3. Creating Macros in Visual Basic
Chapter 4. Storing Macros
Chapter 5. Understanding Macro Commands
Chapter 6. Using Visual Basic Subroutines and Creating Functions
Chapter 7. Creating Interactive Macros
Chapter 8. Using Macros to Format Cells
Chapter 9. Using Variables in Macros
Chapter 10. Creating If/Then/Else Routines
Chapter 11. Exploring Loops
Chapter 12. Adding Controls to Your Worksheets
Index