Checking to see if an object is ready for copy and paste.

[dflak]

I am using the technique I outlined in this article: https://www.excelforum.com/tips-and-...int-xl2pp.html.

This application works perfectly when all the data that is needed to transfer to PowerPoint is already calculated.

I am now working on an application where I am computing the values "on the fly." I am running into errors with copying and pasting ranges and charts as pictures into the PowerPoint. I suspect that I'm overrunning the application. I'm trying to copy something while it is still being calculated. I added some doevents into the code and they don't seem to help. So I added some timing loops. This slows down the application.

I was wondering if there is a more elegant solution: some way to test if an object is ready to copy. Then if it isn't, I'll apply the time delay only then.

[dflak]

I came up with this and it seems to work. The code was failing either on the copy or the paste. So I inserted a named location:

TryAgain:

before the copy section of the code and put in: On Error goto TryAgain.

I turn if off after the paste: On Error goto zero.

Please Login or Register  to view this content.