by Nate Moore | Jun 16, 2014 | Macros and VBA
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...
by Nate Moore | Jun 9, 2014 | Macros and VBA
Excel Video 413 has two more tricks to add to your debugging arsenal. Both tricks relate to how to respond to a macro within a macro. Macros can call (or run) other macros. We’ll call the macro that calls another macro the parent macro. We’ll call the macro that is...
by Nate Moore | Jun 2, 2014 | Macros and VBA
Breakpoints, the topic of Excel Video 412, make your code stop running exactly where you need to analyze your code. If you have a really long macro or code with a lot of loops, breakpoints can save you a lot of time stepping through your code. Watch today to learn how...
by Nate Moore | May 26, 2014 | Macros and VBA
Writing macros and code is great, but when you need to debug problems in your code, start by watching Excel Video 411. The challenge with finding problems in your macros and code is that they generally run so fast it’s hard to tell where the problems are. By choosing...
by Nate Moore | May 19, 2014 | Macros and VBA
Excel Video 410 gives you a behind the scenes look at what the Macro Recorder is doing in Visual Basic for Applications when it records a macro. Watch how I use Alt+F11 to open the Visual Basic Editor and follow along as I record a macro in Excel. If you want to learn...