Paste Special Values losing destination formatting

[mr_newbie]

I have a macro which copies a filtered range and pastes the data into columns in another sheet. I am pasting using the below code:

Please Login or Register  to view this content.

It works fne however I am losing the formatting in the destination table. e.g. One column has been formatted as DATE (DD/MM/YYYY) but when the macro pastes values it pastes as general and values appears as numbers.
Just to confirm, I want to keep the formatting in the destination table, not the source.


Any idea how to resolve this?

Thanks!

[InvisibleMan]

That should work.

Please Login or Register  to view this content.

Suggest you post a sample workbook that demonstrates the problem.

[mr_newbie]

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.

[InvisibleMan]

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.