AutoCalculate and UDF
Ronald, you could force the recalculation of this function
each time there is change somewhere else :
add the following line after the function header :
Application.volatile=true
Rgds
Rog
-----Original Message-----
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.
--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
.
|