There's a book that is very easy to read: John Walkenbach "Excel 2003 Power
Programming With VBA" (http://j-walk.com/ss/books/index.htm). I started with
the xl97 version of this book, then bought the 2k version. I think it's a
good book for both beginers and intermediates, and focused on Excel.
I mostly learn by trying solving people's probelems in newsgroups.
There are also some good advanced book, but i wouldn't start with these ones
(Stephen Bullen "Professional Excel Development.", ...)

I hope this helps
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"vijaya" wrote:

Just a small Information.

I am a beginner in Excel VBA programming.I want to learn Excel VBA, and
write programs efficiently by myself, Cud u please let me know which book I
can follow .

Thanks

"sebastienm" wrote:

Not sure what you are trying to accomplish.

If you want to Copy/Paste the cells, you can use the syntax:
RangeOrigin.Copy RangeDestination
eg: copy rg to cells starting in Z10
Rg.Copy ActiveSheet.Range("$Z$10")
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"vijaya" wrote:

I thought I could copy and paste a formula on to the selected cells, but once
i run the macro, the cells get selected but I could not copy paste it, ihow
can i do this

"vijaya" wrote:

I want to select particular cells . Its like got to select every consecutive
3rd cell of a particular column.

Eg: Say column F, I have to select F3, F6, F9...and so on.

I am not sure if we can use macros and range to program this or how to do,
Is it possible to get this way.Pls let me know

Thanks
Vijaya