Don't forget using the macro recorder to record some code is also a good
resource to learn how things are referenced. Just remember the recorder will
want to "select" everything whereas when you write your own code you don't
need (and generally don't want) to select things to work with them.

I have Walkenbach's Excel 2000 VBA and would recommend it. The format is
easier to follow than some other VBA programming books I've run across, but
no less informative.



"MaBell" wrote:

Hi guys,

I am looking for a good Excel VBA book to learn how to code things like
comparing 2 spreadsheets from 2 different workbbooks and matching cells from
1 column from each, updating rows and inserting rows for new items.

I am pretty confident coding Access VBA and some VB, but I want to learn
more about Excel VBA terminology and such.

--

Thanks in advance,
Matt
(access 2000)