P
Peter W Soady \(UK\)
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
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