Microsoft Excel Question: Download MS Excel PDF
I have a user defined function that does not recalculate?
Answer:
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
Application.Volatile
This will cause the function to be executed whenever a calculation occurs in the workbook