Macros Creation

This query is : Resolved

Ankit (Querist)
Follow

06 June 2009 Hello,

Can you please tell me how to create macros in excel and what are the uses and benefit of using macros in excel.

Please resolve my above query at the earliest

Thanking You

Yours faithfully

CMA Ankur Pandey

CMA Ankur Pandey (Expert)
Follow

06 June 2009 macros is useful in doing repeated task . u can use it when ever u have to do the same task again & again the simple way to create a macro in excel is to record macros......if you are using excel 97-2003 then

Tools----macros------record new macros

follow the instruction and
do your task which u want to do again and again
after that stop the recording of macro...

now press the shortcut key ,which u had entered while recording macro

take care of absolute reference or relative reference of cell

i think it will help u ,for any query send me PM