Getting Run-Time error '1004': Paste method of Worksheet class failed

Hello guys,

So I made this macro which automatically formats data output from our instrument to a form that can be listed. Copies the data and pastes it automatically along with the filename right next to it. It goes through the entire folder and opens up each file and repeats the process.

The problem is that after the first few files I get the "Run-Time error '1004': Paste method of Worksheet class failed" error. The line of code that is in question after debugging is highlighted below.

This is not the case of me copying entire rows nor is it the case of me copying 2,516 or more rows, so I do not see why this is occurring.

Please Login or Register  to view this content.

Any help that you can provide would be most appreciated.

Can you specify the line of code that is causing the error separately? (It doesn't show up as highlighted for me.)

Originally Posted by bmxfreedom

Can you specify the line of code that is causing the error separately? (It doesn't show up as highlighted for me.)

Here you go!

Please Login or Register  to view this content.

I'm having a hard time understanding what your code is trying to accomplish, but I would get rid of the ActiveWorkbook.Close before this paste because closing the workbook causes the copied data to go away. I would recommend naming the workbook with something like wbclose = activeworkbook.name, then using workbooks(wbclose).close after the paste, which would need to be done more specifically than just worksheets("SS"), but something along the lines of ThisWorkbook.Worksheets("SS") so that the code knows where those sheets are located.