Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculateing cells on demand
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculateing cells on demand
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Patient Demand on X Day of the Month | Excel Discussion (Misc queries) | |||
Demand Loading of COM Add-In | Excel Programming | |||
demand planning templates | Excel Worksheet Functions | |||
calculateing | Excel Discussion (Misc queries) | |||
Refresh Excel cells on demand | Excel Programming |