A way to run VBA script run faster by stopping the manipulation on screen.
Disable screen updating
Application.ScreenUpdating = False
Enable screen updating
Application.ScreenUpdating = True
Source
https://www.automateexcel.com/vba/turn-off-screen-updating/