Hi All,
im trying to export cells A2:IU20 in sheet 'StaffTB' to a new CSV file. this works perfectly however Columns F and G need to keep the formatting of yyyy/mm/dd hh:mm:ss, i thought i had it fixed by adding .PasteSpecial xlPasteFormats but this exports it with dd/mm/yyyy hh:mm
Sub...