title: Clear cell contents when another cell is changed
body: <p>In Excel i have two dependent drop down lists that use an if statement to determine what is in the lists depending on what is in cell B8. </p>
  
  <p>I would like to add in the VBA code if B8 is changed then clear any selected items in Cells B14 &amp; B15</p>
  
  <p>I have tried the following</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = Range("B8").Address Then
  Range("B14:B15").Value = ""
  End If
  End Sub
  </code></pre>
  
  <p>But i get the error <code>Ambiguous name detected:Worksheet_Change</code></p>