Issue when copying cells (defaults to mm/dd/yyyy when im wanting dd/mm/yyyy)

Hello All,

I have some code below that looks for any changes and finds the match on the other sheet and updates any changes, however the dates when transferred over go from the UK formatiing of dd/mm/yyyy to the US style date of mm/dd/yyyy making all the dates in the sheet incorrect.

Could someone help and advise how I make it stay the same way? Thanks!"

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

**Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Hello

First of all XLadept I want to thank you for spending the time regading my issue but it doesnt look like it's worked.

I did a search and came up with: - http://stackoverflow.com/questions/9...-automatically

There is some info on there that might help on my code, would you be able to look?

Thanks

MarkPem

Maybe if you format the post:

Please Login or Register  to view this content.