Too much recalculation

  • Thread starter Thread starter Diane Meade
  • Start date Start date
D

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?
 
Hi
you may post your function but normally removing the line
application.volatile should do (depending on your function parameters)
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

force recalculation of function 5
stop automatic recalulation when error occurs 1
Stopping User Defined Functions for Recalculating 4
Active Cell problem 8
avoid recalculating user-defined function when file opened 2
empty arguments recalculation 2
Cell Background Color Change --> Change Event 5
Excel 2007 recalculating custom function when scrollbar is moved? 1

Back
Top