Microsoft Excel Question:
Download Questions PDF

I have a user defined function that does not recalculate?

MS Excel Interview Question
MS Excel Interview Question

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

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
When a button is drawn onto a sheet the assign macro is not displayed. When right-clicking on the button the "Assign Macro" context menu item is not present?My Stop Recording toolbar has disappeared. How do I get it back?