refreshing custom function

  • Thread starter Thread starter Juggernnath
  • Start date Start date
J

Juggernnath

Stupid question, but anyway - I tested my function, and it had some errors.
Any time I made some changes to VBA code, function didn't refreshed in
Worksheet so I had to write a function again in the cell. How can I avoid
this, so result will change in the cell anytime I change a function in VBA?
 
In the first line of the function put

Application.Volatile

Put error handling in your function as well.
 
Back
Top