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. YouAnd#39;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 macrosCreate and debug macros in VBASave macros to the Personal Macro Workbook or other workbooksCreate VBA subroutines and functionsDevelop interactive macrosFormat cells using macrosCreate variables and arraysApply logic to macros with If/Then/Else routinesUse loops to process dataAdd controls to your worksheets

Andnbsp;

Publisher:

McGraw-Hill/Osborne Media

ISBN:

9780071599580

Publication date:

November 2008

Length:

204mm

Width:

200mm

Thickness:

11mm

Weight:

336g

Edition:

illustrated edition

Pages:

191

Illustrations:

Illustrated

Illustrated:

Illustrated

• 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