title: clear dependent dropdown list in excel sheet for multiple rows
body: <p>I am having excel sheet . which is having the field for country and state field 
  when I am changing the country value from united state to canada the state field should be cleared . 
  I have done this using below code for single row But I am not able to do it for multiple rows with same format could you please guide me for the same </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Target.Address = "$B$3" Then
  Cells(3, 26).Value = "Please select"
  End If
  
  End Sub
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/LWtXZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LWtXZ.png" alt="Screenshot"></a></p>