Answers

Question and Answer:

  Home  MS Excel

⟩ I have a user defined function that does not recalculate?

Include all the cells that your UDF depends on in the argument list. Or enter this as the first statement in your Function:

Application.Volatile

This will cause the function to be executed whenever a calculation occurs in the workbook

 201 views

More Questions for you: