title: Excel VBA - Check cell whether it contains piece of text
body: <p>I want to check a range of cells for a certain piece of text. This text is always in my document, except it's cell is variable (column is always B). So I check a range from 1:75 whether any cells contain a piece of text, but it doesn't seem to work.</p>
  
  <pre><code>Dim FoundRange As Range
  Set FoundRange = Cells.Find("5/7 binnen 4h")
  Range("I" &amp; EmptyCell + 2).Value = ... (value of cell I on same row as B)
  </code></pre>
  
  <p>Cell I'm looking for always contains this text <code>Onderhoud 5/7 binnen 4h</code> but its position can vary, that's why I just need to check whether it contains any of it. When I find that cell, I need the value I on the same row.</p>
  
  <p>Any suggestions are welcome!</p>