Date & Month Switching Upon Copy

Hello,

I'm having an issue with some VBA that I've written. The purpose is to copy column by column into a particular format which is exported to be used as a load file. When I copy the column with the Start and End Dates, the dates change from dd/MM/yyyy to M/dd/yyyy or MM/dd/yyyy. Effectively the format is changing and I need it to retain the standard United Kingdom format that the user enters.

I've tried multiple solutions ranging from the .NumberFormat on the entire column, .NumberFormat on every cell by looping, checking the Windows Settings and playing with the Data Types.

Below is some of the example code where the copying is taking place:

Please Login or Register  to view this content.

I've also attached the workbook with a working example of data etc.

Many thanks for all your help!