Reduce screen flicker while macro is running
Page creation date :
Updating cell values, changing active sheets, and opening external Excel files in VBA (macros) can cause flickering behavior because excel screens work accordingto processing. I know something's being handled, but it's not very good for the eye because it's handled faster. To stop this behavior, you can stop updating the screen during processing.
You can control whether the screen can be updated with the Application.ScreenUpdating property. False to stop updating the screen and resume screen refresh by setting true again. Stopping the screen update will speed up the process, so please try it.
' 画面の更新処理を止める
Application.ScreenUpdating = False
' ※ここに画面が更新される処理を記述する
' 画面の更新処理を再開する
Application.ScreenUpdating = True