title: Excel VBA find #N/A
body: <p>I have a worksheet with a formula that returns <code>=NA()</code> under certain conditions. Using VBA, I'd like to find #N/A, but I haven't been able to tweak <a href="https://stackoverflow.com/a/11169920/11498">this answer</a>.</p>
  
  <pre><code>lastrow = .Cells.Find(What:="*", _
                    After:=.Range("A1"), _
                    Lookat:=xlPart, _
                    LookIn:=xlFormulas, _
                    SearchOrder:=xlByRows, _
                    SearchDirection:=xlPrevious, _
                    MatchCase:=False).Row
  </code></pre>
  
  <p>I've tried <code>What:=CVErr(xlErrNA)</code>, <code>What:=xlErrNA</code> and also <code>What:="#N/A"</code> to no avail.</p>
  
  <p>As an added difficulty, I have to take Dutch into account, so <code>What:="#N/A"</code> probably wouldn't even work in Dutch.</p>
  
  <p>Note. I'm asking this question out of curiosity as I haven't found a method online. 
  At this moment, I'm calculating which cells contain <code>=NA()</code></p>