title: Type Mismatch error when using range.find method
body: <p>Could anyone help me with using the range.find method. The type mismatch error keeps coming up and I'm not sure why.</p>
  
  <p>I've tried setting the range variable to a Range, then using Set to define it and I've also tried without using Set, but then it comes up with another error.</p>
  
  <pre><code>Dim r1 As Range
      Set r1 = Range("B:K").Find("WhatToFind").row
  </code></pre>
  
  <p>I expect the above code to give me the row of the WhatToFind, and it is definitely in the worksheet, but still gives the error.</p>
  
  <p>Even if I remove the <code>.Row</code> from the end, I get this error:</p>
  
  <blockquote>
    <p>Run-time error '1004':<br>
    Application or Object defined error</p>
  </blockquote>