Worksheet_Change problem

  • Thread starter Thread starter Ben_2004
  • Start date Start date
B

Ben_2004

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Worksheet_Change() and range question 8
Multiple Fxns in single sheet module 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Correcting "Circular Action" in Worksheet_Change 2
Can Worksheet_Change call itself? 6
Worksheet_Change Event 5
Worksheet_Change() and Range question 3

Back
Top