101 Ready–To–Use Excel Macros

Save time and increase productivity with these macros

Excel macros can make your work easier and you more productive by automating common tasks. But there can be a bit of learning curve when it comes to creating your own macros. If you need immediate help and don′t have weeks to learn Visual Basic for Applications (VBA), you′ve come to the right place. This helpful guide arms you with 101 Excel macros that will solve your issues now!

Inside you′ll find step–by–step instructions for creating these VBA macros, which you can then customize for your applications. This book offers tips, tricks, and detailed explanations along with the actual Excel macros so you can see how they work and where they can be applied. You′ll then be able to immediately implement the code and reuse it in other workbooks as you quickly become a macro pro.

Let Mr. Spreadsheet show you how to:

Go beyond recording simple macros

Dynamically manipulate workbooks and worksheets

Write code to manage cell or range changes

Automate PivotTable features

Use VBA to simplify charting and dashboarding

Write macros to send e–mails directly from Excel

Integrate Excel with other Microsoft Office applications

COMPANION WEBSITE

Visit www.wiley.com/go/101excelmacros to download workbook files for all examples used in the book.

Introduction 1

Part I: Getting Started with Excel Macros 5

Part II: Working with Workbooks 37

Part III: Automating Worksheet Tasks with Macros 71

Part IV: Selecting and Modifying Ranges 103

Part V: Working with Data 137

Part VI: Working with PivotTables 187

Part VII: Manipulating Charts with Macros 233

Part VIII: E–Mailing from Excel 253

Part IX: Integrating Excel and Other Office Applications 273

Index 302

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares Excel and Access tips.

John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona.
Visit his website at http://spreadsheetpage.com.