calculateing cells on demand

[Lars Schouw]

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

 

[Tom Ogilvy]

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.