Forcing VBA to wait until sheet completely calculated

  • Thread starter Thread starter Nirmal Singh
  • Start date Start date
N

Nirmal Singh

Is there some way of checking whether any cells in a worksheet have not been calculated yet?

I want to proceed with my VBA code only when the sheet has been completely calculated.
 
VBA should not proceed until calculate is complete. For example:

Sub asd()
MsgBox ("start calculation")
Application.CalculateFull
MsgBox ("calculation complete")
End Sub

The second message should not be issued until the calculation is, indeed,
complete.
 
Hi Nirmal,

see help for application.calculationstate property.

Regards,
Ivan
Click to expand...


Ivan

I can't find application.calculationstate. I'm using Excel 2000, is it available with that?

Nirmal
 
Back
Top