title: VBA, select row based on cell value
body: <p>My data is dynamic and the only values I must store are greater than zero and are located in column H. Therefore, I must delete the rows that contain 0 in column H before saving the record. </p>
  
  <p>My current selection is just hardcoded below the data set. </p>
  
  <p><strong>EDIT</strong>: How can I change my selection process from hardcode to formula based on Column H values for the entire row before i clear.contents
  *Specifically the portion </p>
  
  <pre><code>`Range("A4:J8").Select
  
      Selection.ClearContents`
  </code></pre>
  
  <p>Here's my code for reference. 
  Thank you!</p>
  
  <pre><code>Sub openCSV() 
      Range("A4:J8").Select
  
      Selection.ClearContents
      Selection.ClearContents
      ActiveWorkbook.Save
      ActiveWorkbook.Save
      SendKeys String:="%slc{enter}", Wait:=True
      Application.Wait (Now + TimeValue("00:00:03"))
      ActiveWindow.Close
  End Sub
  </code></pre>