1004 - Application-defined or object-defined error - Copying chart from excel to word

Hi, this forum has been incredibly helpful in the past, I just hope I can get some help now.

I have a workbook that builds a word based report from data. The code below was working fine for years then I believe IT upgraded our version of Office to 2010 it appears to have brought about this failure.

This particular portion of the word report contains a few tables, and approximately 6 or so charts. The problem occurs when pasting the "Chart 6" onto the second page in the Word doc. The crazy thing is right above the code in red below is the code that completes the same process for "Chart 8" which is fine.

The only difference between the charts is Chart 6 is a bar graph, whereas Chart 8 is a line graph. I just don't know why it is now throwing the 1004 error. Any ideas?

Please Login or Register  to view this content.

I will post more when i get back to the computer today, but it works when i step through the code, but fails with the 1004 error when i let it run as normal, this is why the code appears to be ok on the surface... It was working fine for months then just stop. I know IT is doing things constantly at work, but i find it strange that it could effect just this on chart of many...