Vba: Error when copying to another workbook

Thanks for looking at my Post. I recently added the code below to a workbook so It would Archive my data and provide me with a Hyperlink back to the orginal sheet.
The have recently added the code to a very similar workbook and it debugs at this line:

Please Login or Register  to view this content.

Im not sure why. the only thing that changed to my knowledge is that it had a few more columns.
The code below is the entire module. If you see anything I need to change to make this work please let me know.
Also on the workbook this is working on it puts all the information in Cloumn I it just does seem to hyperlink to the location when I click on it
Thanks again

Please Login or Register  to view this content.

Here is a link to the workbook if someone can take a look.
The module is Finalized by QC
http://sdrv.ms/UbbdqK