any code of that nature will run much faster if your display is hidden while the code is running

sheets(1).visible = false
hide all the sheets involved with the code

pete