I have a code that works correctly up until a point in which a second copy destination code breaks up with an error and for the life of me I cannot figure out why.
Hopefully, someone out there has an answer for me.
The first copy destination works exactly as desired, however the second instance gives an error:
Run-time error '1004':
Application-defined or object-defined error
Both workbooks have sheets that are labeled
wbwork: 100 Ops, 102 Ops, 110 Ops, 112 Ops, 806 Ops, 808 Ops
I don't know how this turns into an object or application-defined error, since neither is being redefined (to my knowledge)
The code resumes past this to operate and then close the subroutine, but this is the code up until the error.
Any help would be greatly appreciated!