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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

VBA and Macros: Microsoft Excel 2010 (MrExcel Library) 1st Edition

4.4 out of 5 stars 35 customer reviews
ISBN-13: 978-0789743145
ISBN-10: 0789743140
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Trade in your item
Get a $2.68
Gift Card.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$11.42 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$27.75 On clicking this link, a new layer will be open
More Buying Choices
58 New from $22.85 40 Used from $11.42

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

$27.75 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • VBA and Macros: Microsoft Excel 2010 (MrExcel Library)
  • +
  • Excel 2010 Power Programming with VBA
Total price: $55.62
Buy the selected items together

Editorial Reviews

From the Back Cover

AUTOMATE REPORTSBUILD FUNCTIONSVISUALIZE DATAWRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! 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

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.

 

NO_CONTENT_IN_FEATURE


Product Details

  • Series: MrExcel Library
  • Paperback: 656 pages
  • Publisher: Que Publishing; 1 edition (July 1, 2010)
  • Language: English
  • ISBN-10: 0789743140
  • ISBN-13: 978-0789743145
  • Product Dimensions: 7 x 1.5 x 8.9 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (35 customer reviews)
  • Amazon Best Sellers Rank: #392,920 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback Verified Purchase
While I am getting some good information out of this book, I have to say it is not for the beginner. Unless you are naturally intuitive, logical, persistant, and have a good understanding of Excel and programming, you will find this book frustrating. The problem is that a lot is left "un-said". Luckily, I have some of the previously mentioned qualities and I was a whiz at the old Lotus macros (soooo much easier) so this isn't completely new to me.

I have since bought the John Walkenbach book, "Excel 2010 Power Programming with VBA" and hightly recommend that for someone just starting out or not very intuitive. Walkenbach fills in a lot more of the gaps and really explains the whole VBA experience from the beginning in good, concise detail. After I get through more of the Walkenbach book, I'll return to this book because it does have a lot of useful information, I'm just not prepared for it yet.
1 Comment 76 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I am an advanced excel user who is semi-new to VBA. Not new to macros at all. And I've done some VBA editing from recorded macros. What this book does not say is, it really is aimed at people who already know VBA. I think it tells you how to put it into better practice for specific results.

It has not been very helpful to me at this point. I've had to go out to the internet to get the code I need to build the excel data model I need for my job.

The book might be helpful to those who already know VBA. But for a beginner, even having used a little VBA, it is confusing.
Comment 41 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I'm quite new to VBA world. I have just begun to study only 5-6 months ago for some projs in my firm. Luckily I'm engineering-mind so I have obtained some good results with this book. The probl is this book doesnt explain you everything and the code in some points is quite hard. The good news is the examples are REALLY useful in a work-environment. My advice is beginning with a entry-level book (i began with Excel VBA Programming for Dummies, john Walkenbach) and THEN to begin reading this book.
Comment 11 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book is undoubtedly the best book available on this subject. I have read a number of books on VBA and this books is simply miles ahead of the other books.

I teach a course in India on Financial Modeling Using Excel to the MBA students in India and I use macros a lot in my models. I was looking for a good book on this subject which I can refer to for this course (as a reference book). What I like the most about this book are the following:

Simplicity in writing style: Everything is very clearly and lucidly explained. It is also written as a self-help guide. You can open your laptop, read each page and experiment with VBA. The author really knows how to communicate with the audience and he does that beautifully in each page in this book.

Arrangement of Topics: The topics in this book are arranged in the best possible way. Most beginners struggle with the macro security issue and the book deals with these annoying issues in the very first chapter itself.

Lots of Short, simple, and extremely powerful examples: This book is full of them. No matter whether you are a beginner, an intermediate user or an advanced user of VBA, you will find something for you in this book.

I will strongly recommend this book to anyone who does serious macro programming.
Comment 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book is very easy to follow. The authors do a good job at breaking each part down. I have minimal computer programming skills and within a week I was able to write a few simple macros. After completing about half the book over the last few weeks I'd say I'm the "VBA guy" in my office of about 10 people.

This book is a great way to set yourself apart in your office. It's mostly for excel, but the VBA platform also works in Word so you'll be able to make simple macros in Word in no time.

Also, the book is mostly enjoyable. I won't say it's novel material, but it's one of the best computer books I've read - not a lot of technical jargon. Again, I HIGHLY RECOMMEND!
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
While I committed to work through this book, I can't give it five stars.
I feel like this book tries to get too practical, too fast.

If teaching is leading someone along a path to a destination, I feel like it has too many distractions. I have over 20 years experience with spreadsheets and 10+ years in teaching and writing training manuals. As a comparison of a good Excel manual, but for functions rather than VBA I would recommend Bern Held's Microsoft Excel Functions & Formulas. It takes you step-by-step from one concept to the next with an exercise.

For example, the first case study has 21 steps showing you how to use a macro to create report. The purpose of the case study is to show why you need to:
1) Use relative references
2) Use special navigation keys
3) Never use AutoSum.

I am creating a supplementary training document for myself which will simplify the exercises.
Comment 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Even if you know VBA you can only get so far without the help of someone who knows the objects and structures and possibilities of Excel. I know Word VBA well, but floundered around with Excel macros until I gave in and bought a book.

This one is accurate, straightforward, and comprehensive. It won't teach you the basics of coding or of VBA, but it will enable intermediate-and-up developers to do useful things with Excel macros.

Sure, the Internet probably has solutions to every individual problem you have...if you can figure out the right search terms and if you can distinguish outdated or secondrate solutions from the best ones. A good book with a coherent approach still outdoes the Internet's collective scraps of wisdom.

Recommended unhesitatingly.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

VBA and Macros: Microsoft Excel 2010 (MrExcel Library)
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
This item: VBA and Macros: Microsoft Excel 2010 (MrExcel Library)

Pages with Related Products. See and discover other items: advanced excel