You re-write the code so both lots can reference the same instance of the document. Your code in post #8 opens the document but fails to make it available outside that instance. Solving that is as trivial as defining the relevant variables at the top of the code module instead of within that sub. Your code in post #8 has some other basic flaws - which the code I provided in post #2 addresses - but that's another issue.