Now I'm confused. You keep referring to worksheets - which are Excel properties - and a workbook named "SetListCreator", but then you seem to refer to it as SetListCreator.doc - which implies a Word document.

Perhaps you would be so good as to explain precisely what you're doing and post the code too.

For a macro to Find content in one document and insert it into another document without all the window switching, see: https://www.msofficeforums.com/128621-post2.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]