- Paperback: 336 pages
- Publisher: Wiley; 1 edition (June 13, 2012)
- Language: English
- ISBN-10: 1118281217
- ISBN-13: 978-1118281215
- Product Dimensions: 7.4 x 0.6 x 9.3 inches
- Shipping Weight: 1.2 pounds
- Average Customer Review: 60 customer reviews
- Amazon Best Sellers Rank: #95,684 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
101 Ready-To-Use Excel Macros 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Customers who bought this item also bought
Customers who viewed this item also viewed
From the Back Cover
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
Visit www.wiley.com/go/101excelmacros to download workbook files for all examples used in the book.
About the Author
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.
Showing 1-8 of 60 reviews
There was a problem filtering reviews right now. Please try again later.
It's a good introductory book for macros in Excel... with one great limitation. As the book goes through example after example of how to select ranges it never really addresses how to select ranges of variable lengths (i.e., lengths in rows or columns for which you don't know how long they are, nor do you need to know). In other words, the book focuses on specific known ranges (i.e., Range("A2:F4")). It does not teach how to select ranges with an unknown parameters... and this is a HUGE LIMITATION - which is why I rated it with 3 stars.