Why This Book?

The real problem in VBA programming is not VBA itself. The formulation of a loop or test, the use of methods and properties, are easily understood as in any programming language and will cause you no trouble after a couple of days. The problem is to get a handle on the complex object libraries within Excel, with their more than a thousand keywords, and to use them efficiently . The focus of this book and the examples presented herein is to explain these object libraries.

In contrast to Excel's Help, the goal of this book is not to offer merely a referenceoften one that says next to nothingof key words. It is our purpose to show the connections among the numerous objects and to demonstrate their use with concrete application examples as they appear in the real world. We do not hesitate to point out problems with Excel where they exist, in order to spare you, the reader, from a fruitless search for errors of which you were not the cause.