Hi
in addition to use application.volatile you may consider also using the
cell references as parameter for your UDF

--
Regards
Frank Kabel
Frankfurt, Germany


Ronald Dodge wrote:
Office 2002, SP2
AutoCalculate Mode

I have created a UDF (User Defined Function) within the workbook as a
separate module for the file that I plan on using the function. As
data is modified in the workbook, all calculations are taken place
EXCEPT for those cells that involves the UDF, which throws the
results off throughout the workbook.

Is there a way to force these UDFs to run at the required times?

The only thing I been able to do to get around the issue is to have
the cells editted in some form or manner, which since the UDF that I
created is for a calculated column of a table, I have to select the
range below the header row, then do a Fill down (Ctrl-D) to force
them to calculate.