Too much recalculation

[Diane Meade]

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?

 

[Frank Kabel]

Hi
you may post your function but normally removing the line
application.volatile should do (depending on your function parameters)

 

[JE McGimpsey]

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)