Run-time error '1004': PasteSpecial method of Range class failed message suggests that Windows is unable to paste.
Usually this is caused by Excel being busy. It may be that it is running another task in the background or that you are midway through a change on another spreadsheet.
Often simply closing Excel and running the process again will resolve the issue. If it still fails, it can be that Excel has got itself confused. Rebooting the computer will clear any unexpected background processes.
.