PasteSpecial method of Range class failed

I keep hitting a snag with this error: PasteSpecial method of Range class failed.

Any help would be greatly appreciated.

Here's the line that was highlighted as causing the problem:

Please Login or Register  to view this content.

Here's the full code:

Please Login or Register  to view this content.

Hi,

Try replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Hope this helps

Thank you ajryan88, your suggestion worked perfectly!