Find problems in a macro by single stepping through it

By single stepping through a macro, you can observe the flow of the macro and the results of each action, and isolate any action that causes an error or produces unwanted results.

1. Open the macro.

   How?

2. Click Single Step on the toolbar.
   
   
3. Click Run on the toolbar.
   
   
4. Click Step to carry out the action shown in the Macro Single Step dialog box.
   
   
5. Click Halt to stop the macro and close the dialog box.
   
   
6. Click Continue to turn off single stepping and run the remainder of the macro.

Tip   To halt a macro while it's running and then single step through it, press CTRL+BREAK.