VBA - finish calculating before next step

[nancymk]

I am creating a loop that will change values on a sheet, then copy and paste values data on another sheet. The other sheet has a lot of CSE formulas, so it takes 5-10 seconds to calculate. Is there code I could add between change the values and copying that would have the program wait till everything was done calculating? I was thinking of just having the file save inbetween the steps, but could you let me know if there is a better way?

Thanks!

 

[sous2817]

Wouldn't adding

Application.Calculate

after value changes work?

 

[nancymk]

Great, thanks!

 

[Ruddles]

Also:-

  Do Until Application.CalculationState = xlDone: DoEvents: Loop