My speculation is that the problem is not with the code you posted, but with the code in "FIRST\GRAND EVALUATIONS.xlsm". To come up with a definitive answer, you need to upload a sample workbook of "FIRST\GRAND EVALUATIONS.xlsm".
Here is what you can do to try to debug the problem.
a. To prove that the problem is in the subordinate workbooks replace "FIRST\GRAND EVALUATIONS.xlsm" and "FIRST - Copy\GRAND EVALUATIONS.xlsm" with workbooks of the same name with the following Macro Code:
If this runs to completion, and I think it will, go to the next step.
b. Create a breakpoint in the real "FIRST\GRAND EVALUATIONS.xlsm" and "FIRST - Copy\GRAND EVALUATIONS.xlsm" at the start of 'Macro1'.
This should help you find the code that stops Macro execution. My speculation again is that it is a .Close statement somewhere.
Lewis
Bookmarks