Intermittent Runtime error 1004 Paste Method of worksheet class failed

I use the following code to copy a chart from one worksheet to another. The code works but fails intermittently on the line "ActiveSheet.Paste" . If I go into Debug, that line will show as hi-lighted in yellow. If I simply click on Run, then Continue or F5 it will proceed and paste the chart. Once in awhile that fails as well. It is very inconsistent, working perhaps ten times and then fails again.

I have searched for solutions, but so far all have failed. I have tried pastespecial methods as well.
Any help would be appreciated.

Please Login or Register  to view this content.

Not a solution: when this happens next, try adding Err to the Watch window in the VBE Editor. What does it show?

It shows: Watch : + : Err : 1004 : Object/ErrObject : ChartData.CopyChart1

PS, I renamed the chart from "Chart 1" to "Chart1", thinking that perhaps the space was causing a problem, but the error still occurs and is inconsistent.

Thank you hrlngrv, It works, but with a few modifications. This error has been haunting me for awhile. Thank again.

Please Login or Register  to view this content.