Peter
Anything from John Walkenbach would be considered excellent.
See a list of those and others here at Debra Dalgleish's site.
http://www.contextures.on.ca/xlbooks.html
Gord Dibben MS Excel MVP
On Sat, 10 Mar 2007 20:58:05 -0000, "Peter W Soady \(UK\)"
wrote:
Hi
Can anyone please recommend a book or books for Excel (or all) VBA
programming please.
I can use the Excel "Record Macro" without any problems and can get some
quite complex code to run and work correctly, but, I need to be able to do a
lot more with it than the "Record Macro" allows. I have included a few
examples of what I need to do:
Query the entire worksheet for data then I have input from an input box.
Conditionally format a cell from the query result
Transfer the complete column (or row) into a pre defined template
These are just a few items and I really need a good book on VBA to allow
this to happen