Copy & Paste from 1 WB to another WB

[tarenlg]

i don't know why the same set of sets sometime works & sometime doesn't.
If i erase my record from 100k row to just remaining 1 row of data. It works.
I just don't know how to fix it.


Is it malfunction of vba? any bugs / cache need to be cleared?


Pls find. Thanks.

[mancubus]

welcome to the forum.
see my forum signature for uploading sample workbook.

[p45cal]

Attaching both files would be good. In the meantime:
1. Is every row in the source file column F guaranteed always to have data in?
2. Is every row in the destination file column D guaranteed always to have data in?

[tarenlg]

Yes. Confirmed. Both always has rows

[tarenlg]

Copy data
28994

Target WB
28995


Attaching both files would be good. In the meantime:
1. Is every row in the source file column F guaranteed always to have data in?
2. Is every row in the destination file column D guaranteed always to have data in?