Hi guys,

Sorry, I realise this is a common query but from I research I just can't see to apply what I've found to my particular issue.

When I run my code I get the following error "Run-time error '1004': Application-defined or object-defined error" with this part of the code:

Please Login or Register  to view this content.
Any help would be much appreciated 


Please Login or Register  to view this content.

This is part of my full code.

Essentially what I'm trying to each is copy specific ranges of 5 sheets from the source workbook to 5 near-identical sheets (only a few static values differ) in 47 other workbooks, 235 sheets in total. Then copy the 5th sheet in each workbook 50 times.

The layout of my workbooks/sheets is something like this;

1a, b, c, d, e, e, e, e, e....
2a, b, c, d, e, e, e, e, e...
3a, b, c, d, e, e, e, e, e..
etc