stop refresh of cells during an optimisation/calculation

A

Andy

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?
 
J

Jacob Skaria

Set screen updating to False....like

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

If this post helps click Yes
 
Top