9780071599580

Excel 2007 Macros Made Easy

by
  • ISBN13:

    9780071599580

  • ISBN10:

    0071599584

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2008-11-17
  • Publisher: McGraw-Hill Education
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $23.00 Save up to $3.45
  • Buy New
    $19.55

    USUALLY SHIPS IN 3-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

Get beyond the basics with Excel 2007 macrosNow 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

Author Biography

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

Recording Macrosp. 1
Editing Macrosp. 19
Creating Macros in Visual Basicp. 35
Storing Macrosp. 53
Understanding Macro Commandsp. 73
Using Visual Basic Subroutines and Creating Functionsp. 91
Creating Interactive Macrosp. 103
Using Macros to Format Cellsp. 119
Using Variables in Macrosp. 133
Creating If/Then/Else Routinesp. 147
Exploring Loopsp. 157
Adding Controls to Your Worksheetsp. 171
Indexp. 183
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review