Forcing VBA to wait until sheet completely calculated
 

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.

Forcing VBA to wait until sheet 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.
--
Gary''s Student


"Nirmal Singh" wrote:



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.

Forcing VBA to wait until sheet completely calculated
 

Hi Nirmal,

see help for application.calculationstate property.

Regards,
Ivan

Forcing VBA to wait until sheet completely calculated
 

On 16 May 2006 05:51:24 -0700, "Ivan Raiminius" wrote:

Hi Nirmal,

see help for application.calculationstate property.

Regards,
Ivan


Ivan

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

Nirmal