At the beginning of your routine enterApplication.EnableCancelKey = xlDisabledOne warning, if there is an error in a loop you want be able to stop theprogram.