title: VBA: How to delete filtered rows in Excel?
body: <p>I have an Excel table that contains some data. By using next vba code I'm trying to filter only blank cells in some fields and delete these rows</p>
  
  <pre><code>ActiveSheet.Range("$A$1:$I$" &amp; lines).AutoFilter Field:=7, Criteria1:= _
          "="
  ActiveSheet.Range("$A$1:$I$" &amp; lines).AutoFilter Field:=8, Criteria1:= _
          "="
  ActiveSheet.Range("$A$1:$I$" &amp; lines).AutoFilter Field:=9, Criteria1:= _
          "="
  ActiveSheet.UsedRange.Offset(1, 0).Resize(ActiveSheet.UsedRange.rows.Count - 1).rows.Delete
  ActiveSheet.ShowAllData
  </code></pre>
  
  <p>It works only if I have blank cells in this columns. 
  But I faced with a problem, when I do not have blank cells, and by using above code all my range is removing from the sheet. How to avoid this issue? Should I change my filter condition or something else?</p>