Tutorial on macros in excel. Vba macros save time as they automate repetitive tasks. An excel macro is an action or a set of actions that you can record give a name save and run as many times as you want and whenever you want. It is a piece of programming code that runs in an excel environment but you dont need to be a coder to program macros. Excel macro is a record and playback tool that simply records your excel steps and the macro will play it back as many times as you want.
Recording a macro is how you tell excel which steps to take when you run the macro. And while you can code a macro using visual basic for applications vba excel also lets you record a macro by using standard commands. Macros help you to save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently. Running a macro executes the commands it contains.