Dependent Dropdowns, clearing dependent value when parent value changes

Hi- I grabbed some code from a previous thread
http://www.excelforum.com/excel-gene...-dropdown.html

to make the second dropdown [D2] go blank when the first is changed [D1]

------------------------------------------------------------------
[Row1]: [D1] <-If I change this value [D2] <-This value should be cleared out
------------------------------------------------------------------

It works great, however, when I delete a row [Row1] this code fires and blanks out the dropdown value [D2] of the next row [Row2] in the table, while leaving the value of the first dropdown [D1] intact. I don't want my [Row2] values to be affected if I happen to delete a row.
How can I make the code only fire when I am specifically changing the value of [D2] and not making other changes (like deleting a row)?

------------------------------------------------------------------
[Row1]: [D1] [D2] <-If I delete this whole row
[Row2]: [D1] [D2] <-The value in D2 of this row gets cleared out. I don't want any values in Row 2 to be affected if I decide to delete Row1
------------------------------------------------------------------

Please Login or Register  to view this content.

Try:-

Please Login or Register  to view this content.

Hi mehmetcik-
I tried your code, substituting the column name of [D2], as follows:

Please Login or Register  to view this content.

I couldn't get it to work
I'm attaching a sample file, I commented out your two lines of additional code, so you can see the before and after

I also tried many substitutions for the

Please Login or Register  to view this content.

line

tried (separately), all of the following

Please Login or Register  to view this content.

adding the code made the original functionality stop working.

I'm sure I'm missing something simple.
help !!!

figured it out, just need to add the first of the two lines, the following solves the problem.

Please Login or Register  to view this content.