Same piece of code (with 20 Modules) produces different results

[VBAProIWish]

Hello all,

I have a large program that spans 20 modules. If I run all 20 modules using a call command without a breakpoint, the code results in providing incorrect data. but if I put in just 1 breakpoint at around module 18 and then resume the code to finish through module 20, the code produces the correct result.

Anyone have any idea how or why this happens and how I can prevent it?

I don't want to have to create a breakpoint just so the code produces the correct result.

Thanks

 

[VBAProIWish]

Yes, that's exactly right. I am refreshing Pivot tables but now that you are saying that is not the cause of the problem, I don't know what is the cause. All I know is that if I stop (break) the code on one of the modules and then resume, it works fine. If I don't break the code it doesn't.

Any more thoughts as to what else the problem could be?

Thanks

 

[RoryA]

Not really as I would be guessing blindly unless I see the code. (this is a bit like turning up to a garage without your car and asking them to diagnose it based on a description that it doesn't work properly... )

 

[VBAProIWish]

Is there some "pause" code that I can simply (and automatically) "pause" the code for like 2 seconds and then automatically resume the code?

 

[RoryA]

You can use DoEvents in a loop , though I always think that should be a last resort. After all, what if 2 seconds is sometimes not quite enough...?

 

[VBAProIWish]

I found and used this code here on every other module and it worked!

Application.Wait (Now + TimeValue("00:00:02"))

Thanks though for sticking with me on this!