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

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...le_functi.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Ray Lau" wrote in message
...
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

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

"Dick Kusleika" wrote in message
...
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...le_functi.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Ray Lau" wrote in message
...
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