How to copy and paste date but maintaining the date format using macros

Hi all,
I have an issue with macros when copying and pasting date, the macro is inter-changing day and month. Original date is DDMMYYYY, but on applying the macro the date ends up as MMDDYYYY. Strange enough is dates above 12 run well except for the onces from 1 to 12.
Below is the macro, will appreciate any assistance on this

wb.Sheets(1).UsedRange.Columns("M").Copy
ThisWorkbook.Sheets(TradeDataSheet).Range("B5").PasteSpecial XlPasteType.xlPasteValuesAndNumberFormats

Try,

Please Login or Register  to view this content.

Thanks but not solving the issue. In the source sheet the date is 10/01/2014 (DDmmYY) but upon running the micros it ends up as 01/10/2014.

It might be a formatting issue. You either format it manually, or

Please Login or Register  to view this content.

Correct looks date format has an issue been able to do it manually.
However my macros how do i plug it in so as to avoid manual intervention.
Thanks.

If the data to format are in column B, add the above code (Post #4) to your existing code.

Thanks it woked much appreciated AB33.