title: VBA Code to Delete Excel 2010
body: <p>I would like a VBA code to delete the content in a cell that’s in Column A when the content in a cell in Column E is cleared same row</p>
  
  <p>This is what I have, here is what I want what I've altered the code and it stops working</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      Dim n As Integer
      For n = 5 To 75 
          Application.EnableEvents = False 
          If VarType(Cells(n, 1)) = vbEmpty Then 
              Cells(n, 4).ClearContents 
              Cells(n, 5).ClearContents 
              Cells(n, 6).ClearContents 
              Application.EnableEvents = True 
          End If 
      Next n 
  End Sub
  </code></pre>
  
  <p>I need this specific code for when content is cleared in Column E (Cells(n,5)) to clear content in column A (Cells(n,1)) without having to go over and delete it</p>