Macro – a set of instructions to perform a particular task that can be performed with limited or no user interaction. Time is money, and using Excel macros is simply better business.
A macro is written in a language called Visual Basic for Applications or VBA for short. They can be simple or complex.
Fed up wondering about what VBA can do for you?
Excel’s really useful BUT it can’t do this, can it?
If I could make Excel do that… but how ? I need an Expert.
This process takes me such a long time… can I do it any faster?
Can I automate this process?
Can Excel do more for me?
The whole above process could occur at the press of a single button, by creating a macro of the procedure.
Macros can also be interactive, by asking the user to make decisions at crucial points in the process. Or they can be fully automated and run without any user prompting what so ever.
|If you repeatedly carry out the same series of steps, when working in Microsoft Office. Then it is likely that those steps could be set up as a macro.
Macros save you time, reduce errors and reduce wear and tear on your mouse finger!