title: Delete All Rows With Errors in a column
body: <p>I am working on a VBA code and part of the code is needed to delete all the rows in the sheet where the text in the column "J" is "#N/A". I have written a code but but I get a Type mismatch error when debugging it.</p>
  
  <p>Here is the code</p>
  
  <pre><code>Dim i As Long
  For i = Cells(Rows.Count, 10).End(xlUp).Row To 1 Step -1
  If Cells(i, 10) = "#N/A" Then Cells(i, 1).EntireRow.Delete
  Next i
  </code></pre>