Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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- |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro not found when spreadsheet viewed in Internet Explorer? | Excel Discussion (Misc queries) | |||
move data/row when certain words are found in cell | Excel Discussion (Misc queries) | |||
Link sources not found | Excel Worksheet Functions | |||
DMW_97.xla not found | Excel Discussion (Misc queries) | |||
TIR.NO.PER function, where do i found it in Office 2003??? | Excel Worksheet Functions |