I am pretty proficient in VBA so I'm not looking for a book on how to program in VBA. I am also pretty proficient in Excel and formulas (although pivot tables are my week spot). What I am looking for is a book that describes all the methods and procedures of all the various objects (i.e. range, cells, etc) and all of the classes. How they work/interact, when they can be used, etc. Also looking for a book on accessing SQL databases from VBA.
Anyone have any suggestions?