What is a Macro?
A macro is a sequence of instructions. This sequence of instructions automates some aspect of Excel you do regularly. When you’re automating some of your works in Excel using Macro, you can perform more efficiently and with fewer errors. For example, you may create a macro to format and print your month-end sales report. After the macro is developed, you can then execute the macro to perform many time-consuming procedures automatically.
A user doesn’t have to be a power user to create and use simple VBA macros. Casual users can simply turn on Excel’s macro recorder: Excel will record your actions and will convert them into a VBA macro. When you execute this macro, Excel performs the actions again.
0 Comments