Thu 28 Jun 2007, 13:30Delegate paul said...
paul has attended:
No courses
How to record / run a macro
how to record / run a macro
Fri 29 Jun 2007, 14:40Trainer Tracy said...
RE: how to record / run a macro
Hi Paul,
If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored and can be run whenever you need to perform the task.
For example, if there is a seris of calculations or formatting that are regularly carried out manually this could be automated as a macro
When you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands.
Macros are created from the Tools > Macros > Macro menu options
Hope this helps
