Hello everyone,

I have run into an odd behavior of UDF's that I don't understand. This applies to excel 97, 2000 and 2002.

I have some cell formulas that call a UDF.

I have an addin that runs a macro that fetches values from these cells. This addin macro does some iterating and the values returned from these cell formulas are different each iteration. Right before the addin macro fetches these values it performs a Range.Calculate to make sure the cell formulas are up to date.

This all works fine when Application.Calculation is set manual, but oddly enough it does not work when set to automatic.

When set to automatic, it looks like the UDF is not getting called either automatically or by my Range.Calculate statement.

Is this a known behavior of UDF functions?

Thanks,

Brian Murphy
Austin, Texas