Error; chart wasn't found

[Guest]

Hallo,

I have created a macro to add charts in the Excel file and resize and move
the charts. When I run the macro then I got the next error message: "Run-time
error '-2147024809 (80070057)': The item with the specified name wasn't
found".
When I check the Excel file I see that all the charts are added on the top
of each other. The crazy thing is that the chartnumbers are starting with
number 36. That's why the macro can't find the chartnumber to move and resize
it.

Can anybody help me with this problem. Thanks.
-Metin-

 

[Debra Dalgleish]

Jon Peltier has sample code for adding charts. Perhaps it will help you
identify the problem in your code:

http://www.peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html