Obviously there are books out there that you can buy,
trawl through and soak up things as you go along. The
best, quickest way of seeing what you can do is to record
yourself doing things like create formulas, charts, combo
boxes in excel. (Tools, Macro, record new macro).
The macro you create will normally be stored in your
personal.xls and you can view the code in there.
Basically, once you start reading the code it should be
clear what does what.
try copying some of it and after some references,
like 'activeworkbook', put a fullstop and a menu will
appear of all the properties applicable
to 'activeworkbook'. They're all pretty self explanatory
when you think about it - any trouble just select one of
the options and press f1. Help will explain most of what
you need to know.
Ta
Steve D
