Hello all,
I have a workbook at work that i use to collate 36 seperate workbooks into one big list. (nicknamed the Master merge)
The macro just opens each workbook in turn, copies the relevant sheets over, then copies the data into the master merges sheets, the deletes the copied sheets, closes the soruce book and then moves onto next workbook.
The data being copied is all numerical but when it gets to around 2/3 of the way through i get an error about "The picture is too large and needs to be truncated".
Ut;s not to do with a set orkbook as i;ve changed the order many times and it;s alwaysaround the 16 - 23 mark it does it.
can anyone give me an idea of why its throwing up this debug error, it has me stumped.
i;ve tried Google but most of the ansers there involve registry edit or uninstalling components of Windows, as this is a works system we don;t have access to any functions like that, and its a thin client system as well so cant un-install anything.
Really buggung me this as there seems to be no pattern to why its happening, any help gratefully recieved.