title: VBA Excel Detect #REF! in the workbook and inform about it
body: <p>Goood afternoon,</p>
  <p>I would like to do the quick check of my workbook in order to detect potential #REF! values.</p>
  <p>I found some good solution here:</p>
  <p><a href="https://stackoverflow.com/questions/19504858/find-all-matches-in-workbook-using-excel-vba">Find all matches in workbook using Excel VBA</a></p>
  <p>but when I apply it it changes all the values found.</p>
  <p>I need something, which will inform me, that the unwanted value appear.</p>
  <p>In this event I modified the following code:</p>
  <pre><code> Sub FindAndExecute()
  
   Dim Sh As Worksheet
   Dim Loc As Range
  
   For Each Sh In ThisWorkbook.Worksheets
   With Sh.UsedRange
      Set Loc = .Cells.Find(What:=&quot;#REF!&quot;)
      If Not Loc Is Nothing Then
          Do Until Loc Is Nothing
              If Loc = True Then
              MsgBox (&quot;Error found&quot;)
              End If
              'Loc.Value = &quot;Answered!&quot;
              Set Loc = .FindNext(Loc)
          Loop
      End If
     End With
     Set Loc = Nothing
   Next
  
  End Sub
  </code></pre>
  <p>But I see no reaction. Is there any way to pop up the messagebox when the #REF value is found throughout the workbook?</p>