Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too much recalculation
I have written several custom functions for a worksheet.
I don't want these functions to recalculate every time. I only want a recalculation when the referenced cells change. In my functions, I put the line: Application.Volatile (False) But when I run my code, even if the code is not activating the worksheets with the custom functions, the functions insist on recalculating. Is there any way I can stop this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too much recalculation
Hi
you may post your function but normally removing the line application.volatile should do (depending on your function parameters) -- Regards Frank Kabel Frankfurt, Germany Diane Meade wrote: I have written several custom functions for a worksheet. I don't want these functions to recalculate every time. I only want a recalculation when the referenced cells change. In my functions, I put the line: Application.Volatile (False) But when I run my code, even if the code is not activating the worksheets with the custom functions, the functions insist on recalculating. Is there any way I can stop this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too much recalculation
You can remove the Application.Volatile line, but you then need to
ensure that all the cell references are in the function arguments, e.g.: Public Function foo(arg1, arg2, arg3) call as =foo(A1, B2, C3) In article , "Diane Meade" wrote: I have written several custom functions for a worksheet. I don't want these functions to recalculate every time. I only want a recalculation when the referenced cells change. In my functions, I put the line: Application.Volatile (False) But when I run my code, even if the code is not activating the worksheets with the custom functions, the functions insist on recalculating. Is there any way I can stop this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculation | Excel Discussion (Misc queries) | |||
recalculation | Excel Discussion (Misc queries) | |||
Recalculation | Excel Worksheet Functions | |||
Recalculation | Excel Discussion (Misc queries) | |||
Recalculation | Excel Programming |