One thing that is often overlooked is using values from worksheet cells
that are not in the function argument list. An example of this could be...

Function EasyMultiply(By Ref Num1 as Double)
EasyMultiply = Num1 * ActiveSheet.Range("B5").Value
End Function

Charles Williams has lots of information here...
http://www.decisionmodels.com/calcsecretsj.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"PatK"

wrote in message
have a "fairly" complex spreadsheet with about 10 worksheets, each with
about 700 rows of info. On two of them, I have created my own user defined
function for some complex calculations to simply the forumula.

The problem is that it is not calculating. I do have calculation set to
Automatic in my options, an if I select the cell, and press F2, enter, it
seems to update. Occasionally, on it's own, it also starts calculating when
I have not touch any of the fields with the formulas in them. F9 does not
make it calculate, either.

With all this data, I really cannot afford to keep rechecking to see if it
re-calculated...it would skew my entire model.

Anyone know why this behavior occurs? I have read many threads on this, and
none of the suggestions work to make it "automatically" calculate.
Thanks!
pat