Includes index.
Unleash the power of Excel with VBA
This sounds like BASIC, so why doesn't it look familiar?
Referring to ranges
User-defined functions
Looping and flow control
R1C1-style formulas
What's new in Excel 2010 and what has changed
Create and manipulate names in VBA
Event programming
Userforms: an introduction
Creating charts
Data mining with advanced filter
Using VBA to create pivot tables
Excel power
Data visualizations and conditional formatting
Reading from and writing to the web
Dashboarding with sparklines in Excel 2010
Automating Word
Arrays
Text file processing
Using Access as a back end to enhance multi-user access to data
Creating classes, records, and collections
Advanced userform techniques
Windows API
Handling errors
Customizing the ribbon to run macros
Creating add-ins.
OBNB doesn't sell books, but you may be able to find a copy at one of these websites:
VBA and macros : Microsoft Excel 2010 by Bill Jelen. ISBN 9780789743145. Published by Que in 2010. Publication and catalogue information, links to buy online and reader comments.
