Bad news - now it's not working properly. Throughout this project, I keep running into a similar problem that seems to be some sort of glitch when copy/pasting between Excel and Powerpoint.
The workbook example I posted above is pared down, in order to fit the size requirement for sharing files here on the forum. In reality, the workbook will have several more sheets to run through.
So, when I added those sheet names to the array you(georgiboy) created, my results are all over the place.
I keep getting various run-time errors. I've researched all of them. I've tried "DoEvents", I've tried a call to a "hold on a minute and wait" function - but nothing works.
Each time I run the script, a random number of pics/tables will copy/paste correctly - and then the script stops. Each time it stops, the specific run-time error is different, as is the line it is thrown on.
I'm SOOO close to having this script working properly. If anybody has any ideas, I'd be most grateful.