What is the best way to make sure I have control overwhen cells are
calculated?

I have some very long running calculations and would like postpone
them until all the pre-conditions are setup.

I could use a boolean flag in an if statement but how do I do that
better inside of my UDF function?

Lars

This is what I do for my own use often even with Arrayformulas using built in
functions:

Public function ABC(rng as Range)
if Range("AB1") = 1 then
ABC = "Pending"
exit sub
End if
End Function

Put a 1 in AB1 when you don't want it to calculate.

--
Regards,
Tom Ogilvy



"Lars Schouw" wrote:

> What is the best way to make sure I have control overwhen cells are
> calculated?
>
> I have some very long running calculations and would like postpone
> them until all the pre-conditions are setup.
>
> I could use a boolean flag in an if statement but how do I do that
> better inside of my UDF function?
>
> Lars
>
>