Want to be an expert in Excel-Macro

Kamaraj Mani. N (Chartered Accountant - Product Manager)   (553 Points)

17 December 2007  

Dear Friends,

Do you want to be an expert in Excel - Macros.

Steps to be followed:

First we have to understand how the Excel works when we give inputs thru Keyboard or mouse.

If we can easily understand the same, we can write 'n' number of macros without the help of VB.

I accept that we have to use VB Code in Macro, but Concepts are much more important than the VB Codes.

Follow the given steps to get a clear idea:

Step 1: Record a new MACRO
Step 2: Select A10, Type "CACLUBINDIA"
Step 3: Stop the MACRO
Step 4: Go to Visual Basic Editor.
Step 5: Read how System has written codes in your macro.

You can understand the codes what system has written in macro. Just try the same with some other Functions. (like set print area, delete sheet....etc)

You can be an expert in macro, if you understand the concept without having Coding Knowledge in VB.

I think i will be helpful to you... please reply and give suggestions...