Excel Macros For Dummies

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

Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.

• Excel

Excel macro basics; excel macro handbook; excel macro guide; what are excel macros?; how do excel macros work?; best excel macros; easiest excel macros; excel automation; automate excel tasks; excel reporting automation; excel programming