| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation speed optimisation - Links and Dependency Tree | Excel Discussion (Misc queries) | |||
| Calculation speed optimisation - Links and Dependency Tree | Excel Worksheet Functions | |||
| Calculation speed optimisation - Links and Dependency Tree | Links and Linking in Excel | |||
| How to stop in the middle of re-calculation for all cells? | Excel Discussion (Misc queries) | |||
| stop screen refresh | Excel Programming | |||
Linear Mode
