Stopping the screen drawing

[Guest]

Hi everyone

What is the command for stopping the excel from drawing new information
temporaraly. I thought it was "application.screendraw = False" but that
doesn't seem to work.

Thanks in advance and kind regards,

 

[Norman Jones]

Hi Russell,

Try:

Application.ScreenUpdating = False

 

[Don Guillett]

and be sure to reset to true at the end