Stop the screen flicker while running the macros

Insert this code at the beginning of the code

Application.ScreenUpdating = False
.

.

.

your Code

.

.

.
The below code goes as the last line
Application.ScreenUpdating = True