Tip Printed from ExcelTip.com
Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
Enter the code line at the begining of the code:
Application.ScreenUpdating = False
Enter the code line at the end of the code to turned back the screen:
Application.ScreenUpdating = True