stop refresh of cells during an optimisation/calculation
 

I have a complex repeated ooptimisation running and wish to speed it up by
stopping the dynamic refreshing of the screen. How is this done?

stop refresh of cells during an optimisation/calculation
 

Set screen updating to False....like

Sub Mac()
Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Andy" wrote:

I have a complex repeated ooptimisation running and wish to speed it up by
stopping the dynamic refreshing of the screen. How is this done?