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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Bloomberg data in an excel file from a script 4
Weird screen refresh problem in Excel 2003 - bits of differentworksheets display. 5
Preventing linked cells from updating 2
Refreshing NON-embedded External Data Connections 1
Pause in a macro 2
Stop running macro button, like Ctrl-Break button 8
Refresh Query Table causing debug error with Background Refresh pr 2
Excel Screen refresh while VBA is running 1

Back
Top