Copy & Past from multiple sheets to one
Hi Prometheus,
If you comment the line:
On Error GoTo CleanUp
What error is reported and which line is highlighted?
---
Regards,
Norman
"Prometheus" wrote in message
oups.com...
The code completes and reports on 38 files.
The 39th is open but the macro doesn't do anything with it. Funny thing
is taking that file out of the directory allows the macro to get to 103
files, but then the same thing occurs: Taking the 103rd file out of the
directory allows the macro to report on over 150 files and then the
same thing happens with yet another file.
There must be something different about those particular files which is
breaking the macro and sending it to "Cleanup".
I have figured that it's not your macro. Which works wonderfully. Can't
thank you enough.
Cheers
Prometheus
|