Help to calculation vs processing state

[lomholt]

Hi everyone,

Could anyone please help me with the following:

I have an excell sheet with a lot of data. When I use

Application.Calculate

the code is faster than the processing. As a result the code after tries to use data which wasn't updated - the code hence breaks.

I have tried to use

Application.Wait (Now + TimeValue("0:00:10"))

but this just "overrules" the processing part and as a result the processing never finishes (36 % finishes approximately).
I have also tried to

 
Do Until Application.CalculationState = xlDone
        DoEvents
 Loop

but I can't get that to work either.

Thanks for your time! Appreciated!

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.