As a macro is being executed, you have the option to evaluate each line of code one at a time.
 Applications panel 
 Run VBA Macro. On the Debug toolbar or Debug menu, click Step Into to continue the execution of the macro one line at a time. Click Continue to resume normal execution of the macro.