I am creating a ss that has six cells with dependent validation (each is dependent on all the previous cells). I would like to have the dependent cells clear when a new selection is made further up the line. So far I've gotten the second cell to clear when I select a new value in the first cell using:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Column = 2 Then
  If Target.Validation.Type = 3 Then
   Application.EnableEvents = False
   Target.Offset(0, 1).ClearContents
  End If
End If

exitHandler:
  Application.EnableEvents = True
  Exit Sub

End Sub
(Which I am shamelessly copying from Contextures.com)
but I'm having trouble figuring out how to expand this so it clears the 3rd cell and on down the line, and I'm totally baffled as to how to have the 3rd cell etc. clear if I select a new value in the 2nd but leave the 1st the same
Any help would be much appreciate.