Error when exporting from excel to powerpoint
Posted on 2014-01-06
I have used this same code countless times, but all of a sudden I'm getting errors. In fact, I execute the same code multiple times in the same macro, but I only seem to have a problem on this one slide. For simplicity, I've extracted just the snippet I'm having trouble with and attached it here. I'm certainly confused why I'm having a problem pasting here, but that is where it is getting hung up.
This was working when I copied just the chart, but when I changed it to copy a range of cells, I started getting this error (I do it both ways for different slides, depending on whether or not I need data that is in a cell outside of the chart).
Also, it seems to be taking an inordinate amount of time to get through the copy step. Again, I've run similar code for years but it's never taken so long to execute. The entire macro exports data to a presentation with 15 slides, and on some computers it has taken upwards of 30-45 seconds to run, which seems ridiculous (that was before I started getting this error). Is there a way I can make this execute more quickly?
As always, your help is appreciated!