title: VBA Excel Loop to Delete Range Based on Value in Column C
body: <p>I am trying to delete a specific range based on whether or not column "C" meets specific criteria. </p>
  
  <p>Currently I have the following:</p>
  
  <pre><code>If Range("C69") = "All values USD Millions." Then
      Range("C69 : H69").Delete shift:=xlUp
  Else Range("A3").Select
  End If
  </code></pre>
  
  <p>I want to turn this into a loop that will search cells "C1" through "C100" for the words "All values USD Millions." and delete the corresponding C though H range. For example, if it found the value in "C15", it would delete Range("C15:H15"). </p>
  
  <p>Unfortunately, I am still learning and all the loops I try create an error. </p>