Guys,
I have a code that will automatically make a powerpoint presentation from several charts in my excel file. I get a runtime error when running the code on a few of the lines where the charts are copied. I hit debug, go to the actual chart in excel click on it, then go back to code and run and it works till the next time the Copy code comes up. So now I have to hit debug like 5 times then physically click the Chart the code errors out on, then continue running the code. If I immediately run the code again after I have went through and clicked the errored out charts, it works perfectly. IE once I have clicked them once I can run the code again and again without the error. Once I close the workbook and reopen does the Runtime error reoccur.
I figure it is a syntax error but not sure why clicking on the chart makes it work???
Any help is greatly appreciated.
Here is the specific code it errors out on
Here is the entire code![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks