Excel 2007 Unable to .pastespecial, Error 'object required'

I am sorry for the cross-posting. I am new to this whole forum thing, and I am going to stick with this one for this problem.

I am running a macro that copies data in a form into two different archives. If one cell in the form contains specific data, it copies all of the information to the second archive. When I run the macro, it brings up the error message

Run-time error '424':
Object required

and highlights

Please Login or Register  to view this content.

Here is th entire code for the macro:

Please Login or Register  to view this content.