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 Step Into from the Debug menu, Excel will run your code one line at a time. You can watch what the code does and how the spreadsheet changes a line at a time. The keyboard shortcut is F8.
Step Into works, but if you have a long macro or a macro with a lot of loops, you’ll get tired of pressing F8. Stay tuned next time for more debugging options.
