Although I, too, will agree with the "no best book" philosophy, my personal favourite is John Walkenback's Excel 200x Power Programming With VBA. I've consumed it cover to cover, and still refer back to it.