title: Find method in another workbook not working as expected
body: <p>Trying to <code>.find</code> cell address from a different workbook:</p>
  <pre><code>Dim ra As Range
  With Workbooks(&quot;Input Nsales.xlsx&quot;).Worksheets(&quot;Sheet1&quot;)
      Set ra = Cells.Find(What:=&quot;Basis&quot;, LookIn:=xlValues)
      If ra Is Nothing Then
          MsgBox (&quot;Not found&quot;)
      Else
          MsgBox (ra.Address)
      End If
  End With
  </code></pre>
  <p>My googling skills are not good enough, please help!</p>
  <p>Edit: Wow thanks for quick answers! One more question, how do I get the column number from above found cell? e.g &quot;2&quot; for &quot;B1&quot;
  This is what I tried but didn't work:</p>
  <pre><code>Dim BasisCol As Integer
  Set BasisCol = ra.Column
  </code></pre>