title: Searching over multiple columns in excel vba
body: <p>I am able to search a text in column A of my spreadsheet by using this</p>
  
  <pre><code>With WB.Sheets("MySheet")
      Set FindRow = .Range("A:A").Find(What:="ProjTemp1", LookIn:=xlValues)
  End With
  </code></pre>
  
  <p>After which I can get the row number by doing <code>FindRow.Row</code></p>
  
  <p>How do I then get back the row number where <code>Column A == "ProjTemp1" &amp;&amp; Column B == "ProjTemp2" &amp;&amp; Column C == "ProjTemp3"</code></p>