here's my 2cents worth ....
depends on how you learn -
if you're a "play around and see what happens" type of person then
record a couple of macros and look at the code generated
to record macros use tools / macro / record new macro ...
do some that sorts stuff
maybe a subtotal
maybe changes font
wouldn't do all in the same macro - it's easier to understand the code
if there's not too many lines
then to run the macros
choose tools / macro / macros & run
and to view the code
choose tools / macro / macros & edit
if you're a "give me the info step by step" type of person then
do a course (2 -3 day one - intro to programing with excel type thing)
if you're a book type person then
get hold of John Walkenbach's "Power Programming with Excel" (i think
that's the title)
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.
