No that's not it I'm afraid. I tried it again to make sure but there was no change. First time through fine, second time through catastrophe.
Realised I hadn't checked the error message so gave it another go. This time with error handling switched off:
First Error Message:
Run-time error '-2147417848 (80010108)':
Method 'Copy' of object 'Sheets' failed
Selected debug and continued to step through code - got a 2nd Error Message on the same line:
Run-time error '9':
Subscript out of range
Tried to step through a couple more times got the
Run-time error '9':
Subscript out of range
error again then processing appeared to continue. However the new workbook was not saved & closed neither was the "template" work book closed as it should. The "processor" reopened the "template" workbook then froze. I killed it off.
Gave it another go. Got the
Run-time error '9':
Subscript out of range
error. It had created the new workbook but only the first four sheets in the list had been copied.
Is there anything I need to reset in anyway between runs?
Thanks again
C
Bookmarks