Quote Originally Posted by marshybid
Just thought, could you not just replace the existing dates for you with UK format dates, then the macro would work the same on my US formatting. Wouldn't it?? Showing what a novice I am :o)
Yes, but I would have to change every one as they are all backwards, and that is beyond the call IMO.

BTW, whenever I get a workbook from the States, the dates are fine, Excel handles the local setting, so how come yours are messed up?