0

I have developed a dependent dropdown sheet. For example when user selects option in cell B2 then further options from C2:L2 are provided.

Now i interested that if any dropdown i.e. B2:E2 are changed than next cells should automatically clear content. I want to do this for all rows independently. I have written this code in VBA however since I have large amount of rows it is difficult

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B2")) Is Nothing Then
        Range("C2:L2").ClearContents
    End If
    If Not Intersect(Target, Range("B3")) Is Nothing Then
        Range("C3:L3").ClearContents
    End If
End Sub

Kindly recommend an alternative solution to do it without too many lines.

James Z
  • 12,209
  • 10
  • 24
  • 44
Jelad
  • 1

0 Answers0