Not to knock books on VBA but, for myself, I usually start by recording
the macro for what I want and then modifying it with VBA. I understand
that this is not an uncommon practice even with professionals. There are
things you can't readily record, for example loops, but they are easy
enough to include by editing and it is good to have a knowledge of the
various commands of Excel VBA. I find myself referring to Walkenbach
quite a lot.
--
James Silverton
Potomac, Maryland
Email, with obvious alterations: not.jim.silverton.at.verizon.not
I know that I learned the most by lurking in the newsgroups. There were names
that I know I could trust -- both in coding style and quality of code.
I'd save the posts that were most interesting.
Later, I'd try coming up with the code myself without posting any code. Then
I'd look to see if my code was close to those trusted posters.
And later, I got comfortable enough to post my efforts. And when that code
wasn't good, there are lots of people who will offer suggestions <vbg>.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
