title: Returning the Cell location of specific value in a separate Workbook
body: <p>To clarify. I have 1 spreadsheet I am creating the VBA in. When the Macro runs, I want the code to find a specific value in a separate WorkBook sheet and return the location of the value in the other WorkBook.</p>
  
  <p>My initial thought was to use HLookUp, however that will only return the value, not the location of the value. My next thought was to use the Find function, but I can't get it to run. The error I get is: Run-time error "438': Object doesn't support this property or method</p>
  
  <pre><code>startValue = enrollBook.Sheets("Pop-FY").Range("D:Z"). _
  Applications.WorksheetFunction. _
  Find(What:=FYString, LookIn:=xlValues)
  </code></pre>
  
  <p>enrollBook is the other workbook. 
  startValue is supposed to be the location of the found value in the other spreadsheet</p>