Hi,

This has cropped up on several other threads but I couldn't find my specific issue hence starting a new thread.

Essentially I have two workbooks A and B. A is a holding front page which stores data temporarily i then have a macro which copies the data into a central store (workbook B), saves the wookbook and the n closes it. There are several security measures in place to ensure it only copies if B is read/write etc however often people using the tool are getting the 'Runtime error 9 "subscript out of range"' error message. The frustrating bit is it is not everytime its run and it doesn't give me the option to debug to see where its failing over. Also on occassion it leaves workbook B open despite the code specifically closing it after saving.

Any ideas would be apprieciated

Chris