I have put a code into the Worsheet_Change function and it works great
If a duplicate value is entered in two cells within the given range
chose in my code, a warning pops up and the duplicate value is eraced.

My problem is, if one puts values into cells by choosing one cell an
then "draging" using the ctrl button (copy) all cells have duplicat
values but the Worksheet_Change doesn't go into action!! Furthermore
When eracing a few cells at a time, by selecting a few cells an
pressing delete, the functions of excel, like "count" etc. are update
but once again, the Worksheet_Change doesn't do my code.

I tried using "SelectionChange" and Calculate, but the same problem.

What can I do

--
Message posted from http://www.ExcelForum.com