In article , Claus Busch
writes
Hi Colin,

Am Thu, 17 Oct 2013 19:11:53 +0100 schrieb Colin Hayes:

OK I think I've found what the issue is. It works fine on direct entry ,
and for pasting of a single cell. If I want to past more than one cell
then it doesn't react.

you get an error if you change many cells in time with Worksheet_Change
or Workbook_SheetChange event.
Therefore I wrote "If Target.count 1 then Exit Sub" into the code.


Regards
Claus B.

Hi Claus

Yes , I see the sense in what you say.

It's a pity pasting several cells in the row from D can't be made to
trigger the date entry in C.



Best Wishes


Colin