title: How to delete an entire row if two cells contain specific text
body: <p>I need VBA code which can delete an entire row, if two cells (which can be in any column of the sheet) contains a specific text.</p>
  
  <p>I have a daily generated print reporting file and in this file exists the text (in a non specific column) <code>"printed BlackWhitepages, total = #"</code> and <code>"printed Colourpages, total = #"</code> also in any column.</p>
  
  <p>The # stands for a number, so in my file there could be 0-99999...., depending on how many pages were printed.</p>
  
  <p>The file has columns from <code>A</code> to <code>BA</code> and thousands of rows, and the <code>Blackwhitepages</code> and <code>Colourpages</code> text could be on each column, depending on the print job.</p>
  
  <p>I want the VBA to look at the entire sheet, and if a row contains <strong><code>"printed BlackWhitepages, total = 0"</code></strong> and <strong><code>"printed Colourpages, total = 0"</code></strong>, the entire row should be deleted.</p>