Cons of Excel Macros
Macros have certain limitations pertaining to them and can be combated by writing the VBA code manually. Some of them are as follows
- A macro doesn’t record what options you select within a dialog box.
- If you need to make any decisions in your process (code), the macro recorder can’t help you make them. you can use the IF statement or other conditional statements.
- The macro recorder can’t throw message boxes to prompt the user.
How to Record a Macro in Excel
Excel Macro is simply a record button that records a set of actions performed on Excel that can be run multiple times. For example, if you have to format some raw data on a weekly basis you can use a macro to record yourself formatting the data once and let Excel automate the task in the future. it’s used to help users save time and avoid performing redundant tasks.