ActiveSheet.Paste

I've been using "Record Macro" function to come up with most of the lines
up there, but it seems that even using exact copy & paste doesn't work.

I tried the following:
ActiveSheet.paste
ActiveCell.paste
Activeworkbook.paste
active... etc, none of them worked.

in the end I just removed the header for "Before save" kind of auto macro,
into a normal user triggered macro, and it finally worked, but sometimes it
fails when the contents of the target paste cells contain a different format
pattern than the source copy format of the cells. in my case it was the way
the Date was formatted on source was different from destination, adjusting
them manually to be the same format fixed the issue. but i don't know if
it'll happen again.