"Bob Phillips" schrieb im
Newsbeitrag ...
Hi Norman,

It seems to work fine for me. I have tried 11121998 and 31122004, no
problems. What is happening when you run it?

It does seem to fail if you enter a date, and then try and
re-enter/change
it (<Overflow in Target.Value), but Chip's version seems to do the
same. I
take it this is not the problem you are getting.

Hi Bob
this was the problem. Maybe Chip should change his macro also to
target.formula :-)

Frank