The Macro Debugger dialog contains the following:Įxecute - Click to run the macro from the current position to either a breakpoint or the end of the macro.
Run the macro using Execute to the next point of interest, or to the end of the macro. Use the various Step functions to understand what is going on in your macro line by line. This enables you to execute your macro up to the point of interest to ensure everything is in the correct state. Insert breakpoints at points of interest. When you debug a macro, you tend to be interested in a particular portion of the code (either to understand how it works, or why it is not working). The right pane shows the variable assignment at that point in the macro. 
The left pane shows the macro you are debugging.
Right-click a macro in the Explorer and select Debug. Click Home tab > Macro panel > Run > Debug. Use the Debug option to test, debug, step-through, track, and edit variable values in your macros.
0 kommentar(er)
