-
Hello bakerman
yes a bad miss by me
what advice would you give for learning VBA...do you recommend any books?
Cheers
Jeff
-
There maybe dozens of books on the market so saying this one or that one is rather difficult.
The macro-recorder is a good place to start. Just record all the steps you take and look what code comes out.
Then you can start by shortening that code by eliminating Select, Selection, Activate because in 99% of the cases it's unnecessary.
A lot of trial and error and visiting forums to view codes and learning from that also helps a lot.
