one of the first steps could be recording macros while you perform
useful tasks in the spreadsheet, then examining your code & stepping
through it to see how it works.
i don't have any links for you, sorry.
Amazon.Com had a book by John Walkenbach on sale for 16.95 plus shipping for
beginning programmers in Excel VBA for Dummies. You might also find it at
Barnes & Noble or some similar bookstore. You can surf the web with VBA
Programming and pick up some links that might be helpful. The one that used
to be a free tutorial was taken over by Microsoft and now they charge you to
use it. Also Chip Pearson, Ron deBruin and Debra Dalgleish have sites that
provide sample code for various common tasks. You can pull up their sites by
searching on their names.
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.