Bob

Many thanks for your reply. I've tried what you've said, and this works
for the first cell B5 but then the macro halts and I get an error
message.

What I want it to do after B5 is then move to C5 and replace text with
17/12/05, then move to D5 and replace text with 24/12/05.

Your help would be very much appreciated.

Thanks, Simon