RE: Macros

Dear Andrew

Thank you for attending Excel Advanced training.

Macros are created when you see yourself repeating similar task day in and day out.

These could be group of actions that you have to carry out for most, if not all of your work books. Or it could be lengthy text that you have to enter in all your workbooks e.g. Company name, Address, etc..

There are few things you have to be aware before you start recording a macro.

Macro records all your actions i.e Mouse clicks and the key strokes. So it is very important that you do not start making mistakes while you are recording a macros!!

It is advisable to get your self familiar with the actions that you intend to record as macros or you could write the actions step by step on a piece of paper.

Remember you can assign a short cut key to the macro or can even attach it to a button on the tool bar.

If you need further help in creating and/or editing Macros please do not hesitate to ask in the forum post!!

it is advisable to cjheck what other delegates have asked in terms of Macros in Excel.

If you believe that macros will help you enormously because you repeat lots of tasks and want to master them along with knowing other great things that you can do with them then please look at our website for the VBA Course which will help you with your job related tasks!!

Hope this helps!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003