Thread: 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.

Hi Nirmal,

see help for application.calculationstate property.

Regards,
Ivan

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.
>

On 16 May 2006 05:51:24 -0700, "Ivan Raiminius" <ivan.raiminius@fleurdesante.cz> 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