Error; chart wasn't found
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- |
Jon Peltier has sample code for adding charts. Perhaps it will help you
identify the problem in your code: http://www.peltiertech.com/Excel/Cha...kChartVBA.html Metin wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com