Paste Special Values losing destination formatting

That should work.

Please Login or Register  to view this content.

Suggest you post a sample workbook that demonstrates the problem.

That didnt work either Its still pasting as General
I guess i'll just have to format each column individually after pasting

e.g.

Please Login or Register  to view this content.

You misunderstand. I'm not saying that code will work any differently. However, I recorded a simple macro which is shown first and then I "cleaned it up" to avoid ".Select ... Selection." Both versions, in my empty workbook, work as expected. That is, they copy a cell value, which happens to be a date, and pastes the value into another cell, which is formatted as a date.

So, if that isn't happening for you, I suspect that the problem lies elsewhere. But, without seeing what you are working with, I cannot investigate or explain what is going wrong.