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.
Bookmarks