I am very novice at this, I need to apply the below to rows with VBA, can anyone advise please.

```
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Cells.Count > 1 Then Exit Sub

    If Not Intersect(Target, Range("A59")) Is Nothing Then
        Range("B59:E59").ClearContents

    End If

     If Target.Cells.Count > 1 Then Exit Sub

    If Not Intersect(Target, Range("B59")) Is Nothing Then
        Range("C59:E59").ClearContents

    End If

    If Target.Cells.Count > 1 Then Exit Sub

    If Not Intersect(Target, Range("C59")) Is Nothing Then
        Range("D59:E59").ClearContents

    End If

    If Target.Cells.Count > 1 Then Exit Sub

    If Not Intersect(Target, Range("D59")) Is Nothing Then
        Range("E59").ClearContents

    End If

End With

```

I have five dependent dropdown list columns each one is dependent of the previous. I am trying to reset the cells once the previous column selection is changed. The above works fine but I do not know how to apply it to all rows or up to 10000 rows for example.

I would very much appreciate the guidance on this

Many thanks
G