Hi - I have a macro that will not complete, and I can not figure out why. The macro is CHECK_for_Sheets_THEN_Copy_DATA:
I have a function, to define "worksheetexist":
It all seems to hang up around the SaveAs macro, which is ran from near the begining. The SaveAs code seems to runs fine by itself. That code is:
Because of message boxes I've placed in the code, the SaveAs macro seems to run twice when it is initiated from the CHECK_for_Sheets_THEN_Copy_DATA macro and does not complete (stops before it actually saves).
I would appreciate any help - Jim A
I've attached my workbook if anybody is interested.
Bookmarks