View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default User Defined Function Not Does Not AutoCalc

If you post the UDF code we can take a look:
The most likely cause is the UDF referencing directly or indirectly cells
that are in the UDF arguemnt/parameter list.


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Henry Stockbridge" wrote in message
...
Hi,

I have created a user defined function that is stored in my personal
macro workbook. When I change a value in one of the referenced cells,
the result does not recalc. AutoCalc is set to true in Tools --
Options, but I still need to F9 to see the resulting value. (Excel
2003.)

Any help you can lend on this is appreciated.

Henry