| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop UDF firing when sheets(n).calculate
Greetings and TIA for your time
I have a UDF which is called by cells only on sheets(2) and is neither a president or dependent of anything in sheets(1) During running code I have sheets(1).calculate in each pass of a loop. For some reason this fires the UDF. It fires once for each instance on sheets(2) This slows the code down considerably How can I stop the UDF firing? -- David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to stop UDF firing when sheets(n).calculate
Hi David,
Is there "Application.Volatile" in the code of the UDF? -- Kind Regards, Niek Otten Microsoft MVP - Excel "David" wrote in message ... Greetings and TIA for your time I have a UDF which is called by cells only on sheets(2) and is neither a president or dependent of anything in sheets(1) During running code I have sheets(1).calculate in each pass of a loop. For some reason this fires the UDF. It fires once for each instance on sheets(2) This slows the code down considerably How can I stop the UDF firing? -- David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to stop UDF firing when sheets(n).calculate
Add this line of code at the beginning of the function. It will keep the
function from recalculating Application.Volatile (False) -- HTH... Jim Thomlinson "David" wrote: Greetings and TIA for your time I have a UDF which is called by cells only on sheets(2) and is neither a president or dependent of anything in sheets(1) During running code I have sheets(1).calculate in each pass of a loop. For some reason this fires the UDF. It fires once for each instance on sheets(2) This slows the code down considerably How can I stop the UDF firing? -- David |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to stop UDF firing when sheets(n).calculate
Nick,
No, no application.volatile ... -- David "Niek Otten" wrote: Hi David, Is there "Application.Volatile" in the code of the UDF? -- Kind Regards, Niek Otten Microsoft MVP - Excel "David" wrote in message ... Greetings and TIA for your time I have a UDF which is called by cells only on sheets(2) and is neither a president or dependent of anything in sheets(1) During running code I have sheets(1).calculate in each pass of a loop. For some reason this fires the UDF. It fires once for each instance on sheets(2) This slows the code down considerably How can I stop the UDF firing? -- David |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to stop UDF firing when sheets(n).calculate
Thanks Jim, much appreciated
-- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| STOP Auto Calculate | Excel Discussion (Misc queries) | |||
| Calculate how much time falls between set start and stop times | Excel Worksheet Functions | |||
| Excel 2002: Formulas stop calculate correctly after 13.4MB | Excel Discussion (Misc queries) | |||
| Stop Worksheet_SelectionChange event from firing? | Excel Programming | |||
| class events stop firing with ADO 2.8 | Excel Programming | |||
Linear Mode
