check the value of a variable in code

[ammartino44]

Hello. How do I check the value of a variable in my code. Can I use the immediate window? Code below. I just want to see the value of firstrow. I guess it's sort of easy to just step through. But what if the code is much larger? Can I use the immediate code to sort of create different scenarios?

Please Login or Register  to view this content.

[MrShorty]

How do I check the value of a variable in my code. Can I use the immediate window?

yes, you can use the immediate window, though I think it is easier to use the locals window, where all active variables and their current values are displayed, or the watch window. This page describes how to use all three windows to examine the current values of variables: http://www.cpearson.com/excel/DebuggingVBA.aspx

Can I use the immediate code to sort of create different scenarios?

Yes, you can. I personally do not use this strategy, so I cannot comment on its utility, but, it is certainly possible to change variables within the immediate window to test scenarios. How useful this is will probably depend more on your skill as a programmer in using the feature.

[shg]

Or you can just hover the cursor over the variable.

[ammartino44]

Thank you my people.

[shg]

You're welcome.