Run-time error 1004. Copy method of chart class failed

Greetings,

Heres a challenge, i cant find a solution to this anywhere.

In EXCEL.

Ive got VB code to copy a Template of a Chart, and then populate it with data.
It needs to create about 40-45 graphs... i do this every monday so its automated for that reason.

anyway, if it creates over around 39 graphs, i get this error:
--
Run-time error '1004'
copy method of Chart class failed.
--

This is the line of code is stops on.

Sheets("TEMPLATE").Select
Sheets("TEMPLATE").Copy after:=Sheets(Sheets.Count)

Sheets("TEMPLATE (2)").Select
Sheets("TEMPLATE (2)").Name = KPR_Sheet

-

Any help would be great.

if i save and close the spreadsheet, it seems to reset the error. ie if i restart it after i have opened it, i can get another 40 odd sheets before it fails.

[855 byte] By [KnightSurfer] at [2008-1-28]