Benifites of Create a MacroIn excel?

The advantage of using macro is the execution speed of the program fragment. When the actual code snippet is to be used, it can be substituted by the name of the macro. The same block of statements, on the other hand, need to be repeatedly hard coded as and when required.

using VBA will give you a lot of power.

you can extend your abilities to perform more in less effort.