Add this line of code at the beginning of the function. It will keep the
function from recalculating

Application.Volatile (False)

--
HTH...

Jim Thomlinson


"David" wrote:

Greetings and TIA for your time
I have a UDF which is called by cells only on sheets(2) and is neither a
president or dependent of anything in sheets(1)
During running code I have sheets(1).calculate in each pass of a loop. For
some reason this fires the UDF. It fires once for each instance on sheets(2)
This slows the code down considerably
How can I stop the UDF firing?
--
David