Microsoft Excel Question:

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