title: Excel: Search for text in specific column
body: <p>In an excel sheet, I search for a keyword to mark the title of the column, that is the easy part. Now I need to search for another string inside this column. The point is that the same string is also present in other columns, but on different rows, so those need to be ignored. The only way I found to do so, is by the method described here: <a href="https://msdn.microsoft.com/en-us/library/office/ff839746.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/office/ff839746.aspx</a></p>
  
  <p>When I try to find the string like this:</p>
  
  <pre><code>Dim moduleCol As Excel.Range = moduleSheet.Cells.Find("Module Naam")
  Dim upstreamRow As Integer
  With moduleSheet.Range(moduleCol, moduleSheet.Cells(moduleSheet.UsedRange.Row, moduleCol.Column))
      upstreamRow = .Find(upstreamEm).Row
  End With
  </code></pre>
  
  <p>It finds the string, but in the wrong column (and therefore at the wrong row). In my example sheet, I know that I search in column 'D', so for testing purposes, I tried:</p>
  
  <pre><code>    Dim upstreamRow As Integer
      Dim testCol As Integer
      With moduleSheet.Range("d1:d500")
          Dim testCell As Excel.Range = .Find(upstreamEm)
          upstreamRow = testCell.Row
          testCol = testCell.Column
      End With
  </code></pre>
  
  <p>Now the string is not found at all, even though it is present in this column (at cell d14). What am I missing? Is there a better way to find it?</p>