Error 1004 - We can't paste because the Copy area and the paste area aren't the same size

Hi all,

I am trying to copy columns from one workbook to another. Whenever I enter only one value (1st cell of the column) I get the error from the subject (error 1004). As soon as I add at least 2 values, then it works.

The code looks as follows:

Please Login or Register  to view this content.

Quite frustrating but I expect this can be solved easily.

Thanks in advance.

Cheers
Julian

Originally Posted by HaHoBe

Hi, Julian,

one value will mean than using CTRL+Down (STRG+PfeilRunter im deutschen Layout) will go to the last cell in that column so that row 4 and row 8 or later cvanīt match for the goven number of cells. I would recommend to go up from the last cell or check on the last row how nany cells need to be copied.

Besides: you are looking for rows, not columns. I find it irritating if people use description which donīt refer to the code being used or use variables that donīt match what they are supposed to be doing.

Ciao,
Holger

Thanks for your reply.

I am still a bit confused as I try to copy values column-wise. Attached a screenshot of the initial template maybe it gets clearer why I am referring to the term column and therefore also used it for the variable naming.

Therefore, I thought this should work as I start below the header rows (at least row 4) and try to copy everything downwards from there.

excel.jpg