Does anyone have a recommendation for an VBA Excel 2007 or 2003 book that would be good for beginners and advanced?
JohnWalkenbach's Power Programming is a good choice http://www.amazon.com/Excel-2003-Power-Programming-VBA/dp/0764540726
Regards
Bob
Bob is correct, I have John Walkenbach's book Excel 2007 Power Programming With VBA, he gives tons of examples and has a CD included with sample code you can tweak and use for your own projects.
Read the page http://www.oaltd.co.uk/ProExcelDev/Default.htm and decide in which category you fit yourself in. The most advanced book will be the second edition of Professional Excel Development. JohnWalkenbach book and Excel 2007 programmers reference at http://www.oaltd.co.uk/ExcelProgRef/Default.htm. I will rate both same, however John's book are more famous as they tend to be more descriptive and kind of beginners reference however the programmers reference is a bit more techy. (In my opinion,)