John Walkenbach, is one of the foremost authorities on Excel. He has written fifty-plus books include Excel 2010 Power Programming with VBA for Excel 2003, 2007 and 2010.
It was John’s Excel 2000 version of Power Programming with VBA that I bought many years ago (showing my age now !) and it is one of the most thumbed books on my bookshelf.
The reason why I am so keen on this book is two fold. Firstly the layout of the book makes it easy to read with lots of pictures to follow. Secondly, and probably most importantly is the CD that comes attached to the inside cover of the book.
300 Excel VBA files
The CD Rom includes just over 300 files used that are explained in the book as well as the whole book in PDF format making it easy to find whatever you want. A word of warning – don’t buy the kindle version of this book as it appears there are formatting issues and you will not get the valuable CD.