Excel 2007 VBA Programmer’s Reference (Programmer to Programmer) by John Green, Stephen Bullen, Rob Bovey and Michael Alexander (Wrox Publishing)

A brilliant reference book for Excel VBA – its the manual that you need when programming.

I always keep it close at hand. Includes useful programming snippets as well as complete code solutions.