Copying & Pasting Ranges & Charts to Multi-Slide PowerPoint Unreliable

[ChrisHook]

All,

I've having the following difficulty. I've written a script to loop through a range, change range values, and copy/paste linked charts and tables to slides. In the presentation, there are about 4 slides.

My current method is unreliable. Some times it'll work, other times it will leave off tables/charts. I think this may be due to either the clipboard filling up or the operations not running consecutively as they should.

Code is below, any and all recommendations are welcome.

Please Login or Register  to view this content.

[ChrisHook]

Another note, when I remove the "On Error Resume Next" i get a "Run-time error '-2147188160 (80048240)'): Shapes.PasteSpecial: Invalid Request. Clipboard is empty or contains data which may not be pasted here"

This occurs with the following code (it seems random as to which line it occurs)

Please Login or Register  to view this content.