How to stop UDF firing when sheets(n).calculate

[Guest]

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?

 

[Niek Otten]

Hi David,

Is there "Application.Volatile" in the code of the UDF?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

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

Application.Volatile (False)

 

[Guest]

Nick,

No, no application.volatile ...
--
David

Hi David,

Is there "Application.Volatile" in the code of the UDF?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Thanks Jim, much appreciated