Manual / Automatic Calculation

[Ray Lau]

Dear all,

When I use automatic / manual calculation, I found that some cell does not
calculate.
The function in the cell is written by me (VBA function), is my program
problem??

Ray

 

[Dick Kusleika]

Ray

That usually means that you haven't included all the inputs to the function
as arguments. Maybe this post will help

http://www.dicks-blog.com/excel/2004/06/volatile_functi.html

 

[Charles Williams]

In addition to the reason Dick gives (cells not referenced as arguments,
which is the most likely reason) there a few other possibilities:
see http://www.decisionModels.com/calcsecretsj.htm


regards
Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com