Actually I might have sorted this using the xlPasteValue
variable.

This pastes the dates as a serial number.

I think I can retrieve the correct parts of the date using
the DAY, MONTH, YEAR functions.

Nick