stop refresh of cells during an optimisation/calculation

  • Thread starter Thread starter Andy
  • Start date Start date
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?
 
Set screen updating to False....like

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

If this post helps click Yes
 
Back
Top