title: How to delete numbers in Excel Filter
body: <p>I have data from A to F column and I want to filter in E column and delete the entire row which contains # and only numbers. (Check image). I used the code and it works for #, but numbers not. In filter the 'Number filter' is not availble so i cant record in macro. </p>
  
  <p>How to change the code? Help me, please.</p>
  
  <p><a href="https://i.stack.imgur.com/nQlE6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nQlE6.png" alt="enter image description here"></a></p>
  
  <pre><code>Sub Macro3()
  Dim ws As Worksheet
  Dim rng1 As Range
  
  Set ws = Sheets("Sheet1")
  Set rng1 = ws.Range(ws.[A2], ws.Cells(Rows.Count, "F").End(xlUp))
  
  With ActiveSheet
          .AutoFilterMode = False
          rng1.AutoFilter Field:=5, Criteria1:="#"
          rng1.Offset(1, 0).EntireRow.Delete
          .AutoFilterMode = False
  End With
  End Sub
  </code></pre>