I created a chase list at work for shop floor but half way through the macro i find and replace . with / . When the macro comes to the end the date format is lost and has become general so the dates are not in order.

Please can some one advise if they is anything i can do .

Best regards
Daniel