Just a follow up on the error, still don't know what it is that causes it but a better solution is - run code, when the msg comes up go to debug, hit Ctrl+Break 'Twice', finish running the code, save and close the file then reopen the file and the problem is gone. no need to add - Application.EnableCancelKey = xlDisabled