Hi Rajesh,
If you want to learn VBA (for Excel and the rest of the Office package) the best place to learn is by picking a project that matters to you, and work through trying to automate it. The reason for this, is that unless it matters to you, you won't keep going.
Start by recording macros and then checking out the code. It's not the best code but it shows the syntax.
Try to make changes as you go, and see what happens.
Post recorded code here, with question of how to improve it.
Use the Search function. There are heaps of code samples on this site; it is a great resource. If you see something that you like, but don't know how it works, ask questions.
You can also buy books. John Walkenbach has written VBA books for every Excel version that I know of. Buy the book that matches your version. Bill Jelen has also written quite a lot of stuff; his latest big book is the 2007 one, which is worth getting your hands on. Check out the bookshop on this site.
You'll find that it takes a while to get the structure of the language. Once you have that, the same structure is used in all the other Office applications; what changes is the objects that you work with.
Above all, stick with it. once you get fluent you can save yourself heaps of time, and do things that you would not consider trying without VBA.
Denis
