View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_3_] James Silverton[_3_] is offline
external usenet poster
 
Posts: 119
Default what is the best book to learn macros indepth

Dave wrote on Mon, 19 Apr 2010 06:28:50 -0500:

John Walkenbach's books are very good to start.


Professional Excel Development by Stephen Bullen, Rob Bovey,
John Green is pretty advanced, but very good.


See if you can find them in your local bookstore/internet site
and you can choose what one(s) you like best.


excel macros wrote:

pls help i want to learn excel macros fast to get the job
.pls help me


Not to knock books on VBA but, for myself, I usually start by recording
the macro for what I want and then modifying it with VBA. I understand
that this is not an uncommon practice even with professionals. There are
things you can't readily record, for example loops, but they are easy
enough to include by editing and it is good to have a knowledge of the
various commands of Excel VBA. I find myself referring to Walkenbach
quite a lot.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not