What does a macro actually do

[Robin]

In excel if it is a Macro file that it updates all related workbooks. I do
not entirely understand this.

 

[Jacob Skaria]

Dear Robin

A macro is a recording of each command and action you perform to complete a
task. Later whenever you need to carry out that task in your worksheets you
just need to run the macro. They will always carry out the same steps in the
same order. Complex ones can be created using the VBE but simpler ones are
created by recording the macro. Try recording one from tools|Macro and view
the code to understand your actions...

If this post helps click Yes

 

[Robin]

Jacob,

Thank you. You explained that well.

Dear Robin

A macro is a recording of each command and action you perform to complete a
task. Later whenever you need to carry out that task in your worksheets you
just need to run the macro. They will always carry out the same steps in the
same order. Complex ones can be created using the VBE but simpler ones are
created by recording the macro. Try recording one from tools|Macro and view
the code to understand your actions...

If this post helps click Yes