Paste special error

[Demon4231]

I'm having problems with pasting values. The error message I get is "PasteSpecial method of Range class failed." The line that is causing the error the first first PasteSpecial line.

Please Login or Register  to view this content.

If I remove the "ThisWorkbook.Unprotect "1234"" line then it will work just fine. Any ideas?

[TMS]

Try moving the workbook unprotect before the copy. I suspect that it is cancelling out the copy so you have nothing to paste.


Regards, TMS

[Leith Ross]

Hello Demon4231,

The line of code VBA is pointing to would not cause the error that is reported. Whether the Workbook is protected or not, executing

Please Login or Register  to view this content.

will not cause a Paste error. I can not really say what the problem is based on this incomplete code sample. To properly troubleshoot this problem, you should post your workbook.

[TMS]

Leith is, of course, correct. I've just done a simple test and putting a workbook protect between the copy and paste doesn't make a difference.

Sorry, TMS

[Demon4231]

Here is the complete section of the code that is being executed.

Please Login or Register  to view this content.

I've tried unprotecting the workbook before running the code and it gave the same error. I've also tested a small version of what its doing and it worked fine, I can't see why it wont paste the data. I can paste the data myself and it works without problems.

[Demon4231]

Ahhh.... I got it. Moving Thisworkbook.Unprotect "1234" above "If Target.Column = 3 Then", doesn't make sense but now it works.