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