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