Speeding up a UDF

[JenniferMurphy]

I have a complicated UDF that makes hundreds of updates to the data on the screen. It takes 10-15 seconds to complete, depending on what else the machine is doing.

I've seen websites that recommend adding code to such UDFs to speed them up, such as

<code>Application.ScreenUpdating = False
<code>ActiveSheet.EnableCalculation = False</code></code>

with the opposite toggle at the end of the code.

Are these helpful, harmful, or negligible?

Are there other global settings that might help?

 

[footoo]

Rick is probably right, but it is easy to make sure by trying it.