Have had something similar
In my case the project worked perfectly when stepped through but when run crashed out with locking errors.
To do with opening and closing multiple Excel files. When stepping through Excel had the time to close down, when run was getting confused with multiple open sessions.
I caren't see the same problem occuring with your code, try out Debug.Print and see if that makes a difference, or call the sleep api to put the prog to sleep for a few nano seconds between operations and see if that makes a difference????