VBA Breakpoint changing calculation results

[tsi]

I have an excel macro. When I run the macro without a breakpoint, the spreadsheet calculates slightly different values than when I run it with the breakpoint. Unfortunately, when the macro is run with the breakpoint, I get the correct values.

Any ideas on what is happening?

Mike

 

[Derek Brown]

Hello and welcome to The Board.
My guess is that your code continues to run before calculation has completed - that would not be a problem when stepping through the code.
You could try adding a 'pause' to give it more time - have a look at the following:
http://www.excelforum.com/excel-programming/675977-vba-calculate-pause.html

 

[tsi]

Derek,

Thanks. I've run into this problem several times in the past 5 years and have become thoroughly frustrated when the macro executed properly when I did it in debug mode, but failed when I ran it normally.

I even inserted MsgBox's in an attempt to "pause" the macro similar to a breakpoint, but it did not affect the outcome. The pause solved the issue, and will save me a lot of future headaches.

Mike

 

[Derek Brown]

Yes, I would expect a message-box to also cause the calculating to 'pause' - as would a VBA 'wait' instruction.
The best solution was, as given, to loop with the all-important "Do Events" within the loop.