The way I started was to record macros to do mundane "chores", like
format cells, do search and/or search/replace, stuff like that, then
open the VBE to see what the code looked like and "play" with the code
that was written, try to modify the code to see what it would do.

Then I went into "Help" and found what each line of code actually did,
then "played" some more.

Eventually, I came to the point where I started trying to code with out
the macro recorder, and looking for interesting topics in Excel's Help.
(Believe it or not, it is rather good [not great], but that is half the
fun [phun?] of figuring out what the programmers are trying to tell you
to make it do what you want it to do!

As for books, most are good.
Personally, I do not recommend the "For Dummies" until you have a
little experience with Excel. While the "For Dummies" books are quite
good, I found them a bit cryptic as a beginner because then tend to
focus on specific examples, not general use tutorials for learning. (I
do own several "For Dummies" books, and do use them quite often as
reference though).


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=547967