title: Excel VBA find string : Error 2015
body: <p>I have to following code snippet ...</p>
  
  <pre><code>  Public Sub FindText(path As String, file As String)
      Dim Found As Range
  
      myText = "test("
  
      MacroBook = ActiveWorkbook.Name
  
      ' Open the File
      Workbooks.Open path &amp; file, ReadOnly:=True, UpdateLinks:=False
      For Each ws In Workbooks(file).Worksheets
       With ws
  
         Set Found = .UsedRange.Find(What:=myText, LookIn:=xlFormulas, _
                        LookAt:=xlPart, MatchCase:=False)
  
         If Not Found Is Nothing Then
          ' do stuff
          ' ...
  </code></pre>
  
  <p>I see in the debugger that Found contains Error 2015! The sheet contains the text I want in the formula.</p>
  
  <p>Any ideas why I'm getting the error?</p>
  
  <p>Thanks</p>