@jaslake; @RoyUK: thanks for your comments.

@neilshaw: you should bear in mind that the people answering the questions do so voluntarily and you will not endear yourself to them by making accusations because you don't understand or like the response given. If it needs any clarification, I *was" offended by the suggestion that I had not run the code but more so by the comment "it had to be said" ... it truly didn't.

It's probably worth noting that neither of the code solutions you have posted will *ever* work if the option to create the new worksheets in the existing workbook is chosen ... you may as well not ask the question.

Regards