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 two pieces of information you can return from your spreadsheet. Notice that the information in the Immediate Window doesn’t update as the code runs and the spreadsheet changes. You have to rerun the code in the Immediate Window for the information to refresh. Note that you don’t have retype the information in the Immediate Window each time. Just put your cursor at the end of the line you want to rerun and click enter.
There are other ways to watch values change as you run code in Excel. Stay tuned for more examples in upcoming Excel Videos.