title: Delete Row + Move up based on partial text match in a Column
body: <p>I want a macro to <strong>delete</strong> any row that <strong>contains</strong> <code>general</code> in Column A and move up (to eliminate a blank row).</p>
  
  <p>I have been attempting this but have been unsuccessful:</p>
  
  <pre><code>Sub format()
  If Worksheets("Sheet1").Range("A1:A20").Value = "general" Then
  Selection.Delete Shift:=xlToUp 
  End If
  End Sub
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/oB3H6.jpg" alt="Sample Screenshot"></p>