VBA Code To Change Pasted Cells as Values

Could try

Please Login or Register  to view this content.

etc.

You are copying on same cells so it will be overwritten.

for values use:

Please Login or Register  to view this content.

Don't forget return Screenupdating at the end.

Try this

Please Login or Register  to view this content.

I also note that in both this and the OP code, every other line overwrites what was done in the preceding line.