Cell wont calculate automaticaly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After running a long macro a cell containing this formula:

"=SI(C148=0;0;Interest_Rate(H16*12;C150;(C68+C101)))"

(SI is IF in french excel)

wont calculate automaticaly anymore! I tried adding "Calculate" at the end
of the Macro and pressing "F9" for recalculation of the whole workbook and
neither worked. I have to go in the formula field and press enter manualy for
the cell to recalculate. The calculation mode is set to automatic!

Anyone have an idea??

thanks in advance!
 
You probably need to specify that your function Interest_Rate() should be
included in recalculation; you do that with Application.Volatile in the code.

"Marks a user-defined function as volatile. A volatile function must be
recalculated whenever calculation occurs in any cells on the worksheet. A
nonvolatile function is recalculated only when the input variables change.
This method has no effect if it's not inside a user-defined function used to
calculate a worksheet cell."
 

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

Cell wont calculate automaticaly! 2
Calculate active sheet on sheet selection 1
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
How to make a cell containing a macro call to be recalculated? 3
Check cell status on Calculate event: resource issues? 2
Force Calculation 1
Cells wont calculate in French version 3
recalculation not recalculating some cells containing user functio 2

Back
Top