Adding a Breakpoint

A breakpoint allows you to halt execution at a specified line of code, rather than having to step through the code from the beginning. There are several ways to add a breakpoint  

Press the Toggle Breakpoint button, on the Debug toolbar. 

If Toolbars(x).Visible = True Then Toolbars(x).Visible = False VisibleBarsCount = VisibleBarsCount 

When you run the macro, the code will execute until the breakpoint is reached, at which point execution will stop. You can now step through the code one statement at a time or examine the values of selected variables. 

Since you can t run a Function procedure, the only way to step through a Function procedure is to add a breakpoint, then recalculate a formula containing the custom function. 

Formula (VBA) f Project jW/1, W tAType — - — -, J/tfatchhxpression 1 C BtBdkVthen/pluelsIrue C Break. Mien rfatue Change.,  

To remove a variable or expression from the Watches pane, select it in the Watches pane, choose Edit Watch from the Debug menu, then press DELETE. Watch expressions are not saved with your code. 

---