Excel VBA Macro - Record Macro

The simplest way to record a Macro without any programming language is by using the Macro Recorder.
It is a great way for beginners to try!

Important! "Please save your work first before running any Macro, as the actions are not Ctrl+V able.

First click on the Record Macro bottom on the Developer Tab -> Assign a name and press ok.

Recording Macro in Excel

 

Then you can do the actions that you want Excel to repeat.
You can do actions like adding formulas, adding text, changing color etc anything you want.

Tips: Plan your actions so that you do not do/undo, this will make your Macro less efficient.
After you are done, press the Stop Recording Bottom at the same place you press the Record Macro bottom.

When you need to run the Macro, you just have to click the Macro button located at the top left corner next to the Visual Basic bottom and press run!

There you go!