Tuesday 11 November 2014

Turn off the screen updating value


Sub Button1_Click ()

 

Application.ScreenUpdating = False

 

‘Turn off the screen updating value false to increase the efficiency of your code and decrease the processing/calculation time for the spreadsheet.

 

End Sub

No comments:

Post a Comment