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.

Hi Nirmal,

see help for application.calculationstate property.

Regards,
Ivan

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

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.