Excel 2000-2007

A great textbook on the basics of Excel programming from a long-time lecturer and translator. The author first tells you what a macro is and in what situations it will become your indispensable helper, and teaches you how to record macros using a recorder. You will then become familiar with the Visual Basic for Applications (VBA) editor environment. After mastering the basic concepts of Excel programming, you will learn what VBA objects are, their properties and methods. The author will introduce some very frequently used commands and constructs and you will practice the technique of writing code with practical examples. Since you will be working with cells very often, one whole chapter is devoted to working with the Range object (cell area). Similarly, other chapters deal with the frequent objects Workbook, Worksheet and Application. Finally, a brief introduction to the problem of error handling in macros.