by Nate Moore | Jun 30, 2014 | Macros and VBA
Excel Video 416 showcases another way to track values in your code and watch when they change. The Watch Window takes a little setup, but once you add watches, you can watch variables, values, and other aspects of your code throughout the macro. As the macro changes...
by Nate Moore | Jun 23, 2014 | Macros and VBA
Excel Video 415 introduces the Immediate Window, one way to keep track of how locations and values in your spreadsheet change as your macro or VBA code runs. Watch for two ways to open the Immediate Window, two commands to get information in the Immediate Window, and...
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...
