Hi KRB
Excel VBA Macro Programming, Richard Shepherd, Osbourne McGraw Hill
centres around an introduction to VBA and the development of an add-in with 21 macros that perform various (useful) tasks.
However, I do believe that if you are new to VBA (and to programming in general) then Excel Programming for Dummies by John Walkenbach is an ideal place to start and even better (far more long term potential) is Bill Jelen's VBA and Macros for Microsoft Excel - it really is an excellent book with plenty of real world macro examples.
Hope this helps!
Best regards
Richard