The macro recorder is a really useful tool that we have at our disposal when it comes to writing visual basic code.

The macro recorder is great for learning some of the coding structure in VBA and it's really helpful if we are looking for the correct syntax to identify a certain object in Excel.

However, the macro recorder does not write the most efficient code, and all of our actions get recorded even if we make a mistake whilst recording leading to lots of superfluous code.

Some actions such as using input boxes or message boxes cannot be recorded and what's more, the macro recorder will not write logical syntax or looping code.

Finally, not all actions in Excel will be recorded by the macro recorder.

In order to write the most efficient code, we need to understand Excel VBAs object model and VBA programming fundamentals.