User Defined Functions

[Jase]

Hi Guys

I am using a user defined function that I wrote in the
code of the workbook, and it works fine. Except for the
fact that when I change data on the sheet that it is
referencing then the formula does not recalculate. Do you
know how to change this?

Thanks heaps
Jase

 

[Laura Cook]

Jase-

You might find this site useful:

http://www.decisionmodels.com/calcsecretsj.htm#nocalc

 

[Earl Kiosterud]

Laura,

If this is XL97, be sure to have service releases SR1 and SR2 installed.

 

[Arvi Laanemets]

Hi

From Excel2000 Help:
<
Volatile Method Example

This example marks the user-defined function "My_Func" as volatile. The
function will be recalculated whenever calculation occurs in any cells on
the worksheet on which this function appears.

Function My_Func()
Application.Volatile
'
' Remainder of the function
'
End Function
Arvi Laanemets

 

[Bernard Liengme]

If the variables used in the UDF are all specified in the arguments, then
Volatile is not needed.
If they are not all passed as arguments then the UDF is poorly coded.
Would help if we saw the code.

Bernard