title: Change cell to clear content of other cells
body: <p>i want to clear the cells in column C D E if date change in column B
  but only cells in same row where date is changed (Date =Sheet1!c2) so date is from sheet 1 but from different cells and different rows 
  <a href="http://www.keepandshare.com/doc12/24886/zzz-xlsm-15k" rel="nofollow">Sample xls file</a></p>
  
  <p>This is what i did but its not working until manually change date in Column B sheet 2:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range) 
  If Not Intersect(Target, Range("b1:b100")) Is Nothing Then 
      Cells(Target.Row, 3) = "" 
      Cells(Target.Row, 4) = "" 
      Cells(Target.Row, 5) = "" 
  End If 
  End Sub
  </code></pre>