title: Search for word and clear cell if it contains that word
body: <p>I have column "A1" which list names and some names ending with totals (subtotals). I need a vba code to go through each cell, and if cell contains the word "total", clear that cell and if not move on to the next one. Do this until cell before the cell that contains grand total. </p>
  
  <p>Using the code below, it only looks for totals and not cells that contains more than that "Derek Smith Total". I would also need to add do it until the cell before "Grand Total". </p>
  
  <pre><code>Sub testing101()
  
      Dim lRow As Long
      Dim iCntr As Long
      lRow = 130
      For iCntr = lRow To 1 Step -1
          If Cells(iCntr, 1).Value = "*total*" Then
             Cells(iCntr, 1).Select
             Selection.ClearContents
          End If
      Next
  
  End Sub
  </code></pre>