VBA date copy/paste problem

CS post says that when he runs the VBA code, it copies dates from one place to another incorrectly. On examination of his sample file, some dates are pasted as date values and some are pasted as text. The ones pasted as text are correct but the ones pasted as values reverse the day and month.

I used his file and ran his code and it worked perfectly.

I suspect the issue is somehow related to the regional settings. If someone uses European date formats and would like to try this the thread is worth 20 points and is not locked.

https://www.excelforum.com/commercia...sometimes.html