VBA and Macros: Microsoft Excel 2010 (MrExcel Library) and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading VBA and Macros: Microsoft Excel 2010 (MrExcel Library) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

VBA and Macros: Microsoft Excel 2010 (MrExcel Library) [Paperback]

Bill Jelen , Tracy Syrstad
4.2 out of 5 stars  See all reviews (8 customer reviews)
RRP: 24.99
Price: 16.99 & FREE Delivery in the UK. Details
You Save: 8.00 (32%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 22 Aug.? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 13.29  
Paperback 16.99  
There is a newer edition of this item:
Excel 2013 VBA and Macros (MrExcel Library) Excel 2013 VBA and Macros (MrExcel Library) 4.5 out of 5 stars (2)
In stock.

Book Description

21 Jun 2010 MrExcel Library







Microsoft Excel 2010




Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.



• Work efficiently with ranges, cells, and R1C1-style formulas

• Build super-fast applications with arrays

• Customize the Excel 2010 Ribbon to run your macros

• Write Excel 2010 VBA code that works on older versions of Excel

• Create custom dialog boxes to collect information from your users

• Use error handling to make your VBA scripts more resilient

• Use Web queries to import data from virtually any online source

• Master advanced techniques such as classes and collections

• Use Excel VBA to control other Office programs…even control Windows itself,

via the Windows API

• Create add-ins to share or sell your programs


About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will


• Dramatically increase your productivity—saving you 50 hours a year or more

• Present proven, creative strategies for solving real-world problems

• Show you how to get great results, no matter how much data you have

• Help you avoid critical mistakes that even experienced users make



Frequently Bought Together

VBA and Macros: Microsoft Excel 2010 (MrExcel Library) + Pivot Table Data Crunching: Microsoft Excel 2010 (MrExcel Library)
Buy the selected items together

Product details

  • Paperback: 656 pages
  • Publisher: QUE; 1 edition (21 Jun 2010)
  • Language: English
  • ISBN-10: 0789743140
  • ISBN-13: 978-0789743145
  • Product Dimensions: 23 x 17.8 x 3.3 cm
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Bestsellers Rank: 33,314 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques needed to automate virtually any Excel task and customize virtually any Excel report or business solution. Bill Jelen ("MrExcel") and top Excel VBA consultant Tracy Syrstad begin with the absolute basics, including ranges, user-defined functions, looping, flow control, R1C1-style formulas, and event programming. Next, they cover all this, and much more: " Automating Excel 2010's brand-new features " Writing Excel 2010 code that works with older versions of Excel " Creating charts, PivotTables, and other data visualizations " Mining data with Excel's Advanced Filter " Reading from and writing to the Web " Using XML from within Excel " Using Microsoft Access as a back end to enhance multi-user access to data " Handling errors " Customizing the Excel 2010 Ribbon to run macros This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.


  • The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve
  • Shows how to automate powerful new Excel 2010 features such as Sparklines
  • Includes crucial information on making Excel 2010 VBA code work with older versions
  • Co-authored by Excel legend and Microsoft MVP Bill Jelen ("MrExcel") as part of his new MrExcel's Library series

About the Author

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Financemagazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches—working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen, and his sons, Josh and Zeke.


Tracy Syrstadis the project manager for the MrExcel consulting team. She was introduced to Excel VBA by a co-worker who encouraged her to learn VBA by recording steps and then modifying the code as needed. Her first macro was a simple lookup and highlight for a parts index, although it hardly seemed simple then. But she was encouraged by this success and others to follow. She’ll never forget the day when it all clicked. She hopes this book will bring that click to its readers sooner and with less frustration. She lives near Sioux Falls, South Dakota, with her husband, John.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4.2 out of 5 stars
4.2 out of 5 stars
Most Helpful Customer Reviews
7 of 7 people found the following review helpful
5.0 out of 5 stars This book is a gold mine 27 Jan 2012
By Zenoe
This is a good book for both the complete novice and the more experienced with VBA. Written in an almost conversational, easy, and fun to read style and with really insightful explanations (f.ex. its intro to object-oriented programming is the best I have seen in any book), it also contains lots of extremely useful examples and information. The chapter on using ADO.NET to store and retrieve data in Access while using Excel as a front-end (i.e. separating the data and the application) is particularly useful. I found that the more advanced topics in the book does require the reader to be able to fill in the gaps, which however should not be any problem if one already has some VBA experience (as I do) (or if you have worked through the entire book). This book is a gold mine both as a learning resource and reference!
Comment | 
Was this review helpful to you?
5 of 5 people found the following review helpful
Format:Kindle Edition|Verified Purchase
VBA is no picnic, and I don't think that you will ever find an "easy 10 steps tutorial". If you want to learn VBA, you must be ready to invest much time.
Often many books waste our previous time on explaining everything, 100 pages on the User Interface and all the options, then some silly examples ("Hello World") ad nauseum.
Not this one: it combines some practical examples with simple code, or some very complex code for you to use without trying to understand it. The first 3 chapters are already a gold mine, by explaining how to correct the macro recorder, how to make sure to get the full range of data, and how to select any kind of range. Those are fantastic tips, which you find nowhere else.
After that you dive in the overwhelming range of VBA features, and you can keep this book as wonderful reference.
As always the Kindle version is not the best, especially with the images made of the source code.
This book has a few defects, I have the feeling that it mixes some very complex subjects (f.i. the Events) with more simple ones (R1C1 formulas), and some paragraphs are very obscure. Just pass them and move to the next, there is enough to learn in the easy parts to keep you busy.
I have read 2 more books about VBA: one is a very simple introduction, and the other is also a very big book, which made me sleep. This one is good.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
4.0 out of 5 stars Great book 31 May 2012
By Frank
Format:Paperback|Verified Purchase
I have not read cover to cover - I use this as a reference. It is fantastic - well layed out.
This has many tips I have used already.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
3.0 out of 5 stars Mr Excel 1 Oct 2012
By Mac
Format:Paperback|Verified Purchase
A well written book with plenty of examples. You need some Excel proficiency before hand otherwise the book is challenging. My Excel experience is intermediate and I found working with the book pretty reasonable. My inexperience is what added time to my practice sessions, the book had good examples and explained things really well.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category