Application.Volatile

[Eileen]

How can I add Application.Volatile to my user defined
formular ?

 

[JE McGimpsey]

You can add Application.Volatile to a User Defined Formula/Function by
entering in on its own line in the code.

Public Sub foo()
Application.Volatile
'Existing code
End sub


If you're unfamiliar with User Defined Functions, see David McRitchie's
"Getting Started with Macros and User Defined Functions":

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Frank Kabel]

Hi
just simply insert this as the first line in your function e.g.

function your_function()
application.volatile
'your existing code
end function

 

[JE McGimpsey]

Should have been

Public Function foo()
...
End Function

obviously.