All of the debugging tools we’ve discussed so far assume that you’re running sequentially through a macro, from beginning to end. In Excel Video 414 I’ll show you 3 ways to change which line of code runs next. You can skip ahead in a macro, back up and rerun code, or go wherever you need to in order to debug your macro. Watch for the right-click options, the Debug menu options, and simply dragging the yellow arrow to choose which line of code runs next. Also note the difference between Run to Cursor, which runs code up to the line you choose, and Set Next Statement, which controls which line of code runs next but does not run the lines of code in between.
Stay tuned. In the next Excel Videos we’ll discuss ways to get the Visual Basic Editor to report information like the cell you’re in, the value in that cell, and much more.