Quote Originally Posted by snb
But disabling autocalculation is amputating the core function of a spreadsheet.

I don't think it's very complicated to get rid of the whole UDF you introduced.
Hi snb,
I agree with you wholeheartedly, that is why I don't like to do disable the autocalculation for the sheet where the function formulas reside, and yes form what you showed me it would probably not be too difficult to get rid of the UDF all together.

What I was hoping for is that there is a way to prevent the UDF from "running" if changes are made to the workbook that doesn't affect the input and results of the formulas making use of the UDF.

Regards,
vanhunk