A basic book for getting started that I would recommend is the Master Visually Series Excel VBA Programming.
There are many screen shots... and the book covers a simple task in two pages... this makes it easy to go back and reference too.
Not very advanced... but it goes through the basics and is great for someone just starting to learn VBA. Discusses with blocks... loops... gets into forms... and has a lot of info on manupulating sheets and ranges.
Plus it's only about $25.