run time error only on drop down list columns

[vze]

I have several columns in this excel sheet with 2 being drop down lists.
Root cause column is a drop down
Sub root cause is a dependent drop down list (to the value selected in root cause)

While testing the excel, I found if I select the values in root cause/sub root cause and hit delete I get a run time error.
I want to be able to clear the values like this as a user may want to mass select rows and clear.

See attached example and code

 

[vze]

I have several columns in this excel sheet with 2 being drop down lists.
Root cause column is a drop down
Sub root cause is a dependent drop down list (to the value selected in root cause)

While testing the excel, I found if I select the values in root cause/sub root cause and hit delete I get a run time error.
I want to be able to clear the values like this as a user may want to mass select rows and clear.

See attached example and code

Code is :
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 9 Then
If Target.Validation.Type = 3 Then
Target.Offset(0, 1).Value = ""
End If
End If

If Target.Column = 9 Then
If Target.Value = "" Then
Target.Offset(0, 1).Value = ""
End If
End If
Application.EnableEvents = True
End Sub