Runtime 1004 - clipboard error

[alan_warn]

I have a simple macro that carries out a number of of copy/paste special actions on the basis of a menu pick to update the information in a chart.

The problem is that half the time when I call the macro there are no problems and the rest of the time I get the following error

"runtime error 1004 pastespecial method of range class failed"


When prompted to debug, the highlighted problem line could be any one of the 4 paste special lines in the code below.

What I don't understand is why the error doesn't occur everytime? If there was a problem with the code I would expect it to always fail?

This leads me to suspect that the problem is something to do with the clipboard and the way it is filled/emptied?

I think a lot of people have this problem so any suggestions greatefully received.

Please Login or Register  to view this content.

[mrice]

For errors that seem to occur some times and not others its always worth trying sprinkling the code with the DoEvents statement which releases resources to other applications to do what they need to do before Excel continues.

[JosephP]

you may also avoid the clipboard-replace

Please Login or Register  to view this content.

by

Please Login or Register  to view this content.

for instance