Table of Contents
Introduction 1
Part 1: Holy Macro Batman! 7
Chapter 1: Macro Fundamentals 9
Chapter 2: Getting Cozy with the Visual Basic Editor 29
Chapter 3: The Anatomy of Macros 43
Part 2: Making Short Work of Workbook Tasks 57
Chapter 4: Working with Workbooks 59
Chapter 5: Working with Worksheets 81
Part 3: One-Touch Data Manipulation 107
Chapter 6: Feeling at Home on the Range 109
Chapter 7: Manipulating Data with Macros 129
Part 4: Macro-Charging Reports and Emails 163
Chapter 8: Automating Common Reporting Tasks 165
Chapter 9: Sending Emails from Excel 199
Chapter 10: Wrangling External Data with Macros 217
Part 5: Part of Tens 235
Chapter 11: Ten Handy Visual Basic Editor Tips 237
Chapter 12: Ten Places to Turn for Macro Help 247
Chapter 13: Ten Ways to Speed Up Your Macros 253
Index 263