Don't let the reference to Macros in the title fool you; the bulk of this book is about the Excel object model, so it is very useful for Excel VBA programming.

It's very well done and very useful. I like the style, and the level of information (detail) is just right. I recommend it strongly for anyone doing Excel VBA.