John's book are terrific and I have one on my desk too, but don't overlook
one of the most useful tools there is in the Macro Recorder. Bearing in mind
that it captures just about everything you do, so there is a bunch of
extraneous junk that can be weeded out. But learning what stays and goes a
long way to proper programming.

Hint: selecting is almost never necessary, so generally when you see
"Select" followed by "Selection" you can eliminate both statements and
concatenate the strings.

HTH,

Smitty

"Stu" wrote:

Yep, got to recommend Mr. Walkenbach's Power Programing. When it comes to VBA
he's the man, plus its a thick book so stops your papers blowing arround when
you not reading it.

"Sena" wrote:

Hi,

I am quite good at normal worksheets and wish to learn a bit of programming
to automate ( basic stuff ). Is there website that I can refer to ?

Thanks
--
Cheers !