Excel 2007 Macros Made Easy

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

(Computer Bookshops Limited)

Bli först med att recensera och betygsätt boken Excel 2007 Macros Made Easy - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

Gail Perry (Indianapolis, IN) is a CPA, author and software trainer from Indianapolis, IN. She has been editing the TurboTax product documentation for Intuit for the past several years. In addition, she's written several books on Excel, including Excel Answers 2000! for Osborne.

(Computer Bookshops Limited)

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

(Computer Bookshops Limited)