User Defined Functions

  • Thread starter Thread starter Jase
  • Start date Start date
J

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,

If this is XL97, be sure to have service releases SR1 and SR2 installed.
 
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
 
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
 
Back
Top