Part III
Programming Concepts
In this part . . .
Discover the essential elements of Excel programming: variables, constants, data types, operators, arrays, and so on
Get acquainted with Range objects — you’ll be glad you did
Find out why VBA functions (and also Excel worksheet functions) are important
Discover the essence of programming: decision-making and looping
See how to run code automatically when certain things occur
Find out about the different types of errors and why error handling is important
Know what to do when good code does bad things: Get initiated into the bug extermination club
See lots and lots of examples — some are mainly informative, and many are actually useful
Check out the video instruction for applying Excel functions at www.dummies.com/extrasexcelvbaprogramming
.