I have a program that allows me to "copy data to clip board". When I paste the data into excel it works a treat and has the correct date values. However, when I use the simple macro below:
It transposes the day and the month around. Sadly, it is not a formatting headache as I thought I could just go in and amend it in formats but it actuall has moved it around and thinks the month is the day and vice versa. Any ideas on why and any cunning ideas on a workaround?
Many thanks in advance, Alan.