How do you print variable values? 2

[monak]

I am having trouble testing what values I am getting in my variables. I know the command is "Print". I tried Print and just the variable but a error saying I need a object to use this command? How can I get my values to print?

 

[SkipVought]

monak,

Debug.Print val1, val2, .... valn

will send the value(s) to the Immediate Window.

Hope this helps Skip,
SkipAndMary1017@mindspring.com

 

[bryanbayfield]

If you want to see how the value of your variable changes over the course of your macro, you could always try adding it to the "Watch" window.

There is an icon to do this on the toolbar. You will of course have to make the Watch window visible (use the View pull-down menu to do this) and you will have to step through the macro in break mode.

 

[monak]

Thank you so much for your help!!! I will try both of these sugestions.