When you paste in Excel, you are not just pasting the values. By default, you are also pasting formulas, formatting, comments, and any data validation of the cell(s) that you copied.

If you only wants to paste one of those and not the others, you use Paste Special. I use it all the time when I want to copy the value of a cell that has a formula to another cell.

Same thing in macros. You need to use a PasteSpecial VBA command and it looks something like this...