Interesting. I am passing values to the function, and one of those values is
performing a vlookup against another "fixed" table in the file (ie, I point
to it "directly" from the function). So, I guess I am doing that, but then,
what is the "fix" or alternative? (ie, "don't do that ? :-)


"Jim Cone" wrote:

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