I have asked this question before but never received a response, and I have the same problem so here it goes again:

I am copying data from one workbook to another. When it tries to pastespecial, it brings up this error message:


Run-time error '1004':
PasteSpecial method of Range class failed


and it highlights this line of code in the debugger

Please Login or Register  to view this content.

In other portions of my code I copy the same data and paste it to other workbooks, but I have no problems.

Here is the relevant code:

Please Login or Register  to view this content.