I have columns with of dates. eg 1/07/2009 meaning 1 July 2009. When I copy
this date using VBA and paste it to another range, it changes to 7/01/2009
and produces incorrect reports ie as 7 January 2009. It is obviously a US
date thing but I don't know how to fix it.

Please help...