The "Excel 200x Power Programming with VBA" series from John Walkenbachis an invaluable tool for learning Excel VBA.