As a macro is being executed, you have the option to evaluate each line of code one at a time.
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.