title: VBA Vlookup "application-defined or object-defined" error in excel
body: <p>I tried to use the excel VBA vlookup, but I get this error &quot;application-defined or object-defined&quot; for line number 4.</p>
  <pre><code>Dim SearchRange As Range
  Dim FindRow As Range
  Set SearchRange = Sheet2.Range(&quot;A4&quot;, Sheet2.Range(&quot;A65536&quot;).End(xlUp))
  
  Set FindRow = SearchRange.Find(&quot;Car 4&quot;, LookIn:=xlValues, lookat:=xlWhole)
  </code></pre>