title: Can I set a function as criteria in an autofilter in excel?
body: <p>What I want to do is, I want to filter a range by an <code>Autofilter</code>. The criteria is the <code>Vlookup</code> returns value <code>#N/A</code> or not. I need to handle this language independent. The English return value of <code>Vlookup</code> is <code>#N/A</code> and the German return value of <code>Vlookup</code> is <code>#NV</code>, therefore I want to use the function <code>WorksheetFunction.IsNA(arg)</code>. </p>
  
  <p>Is it possible to use this function as criteria for an <code>Autofilter</code> in excel?</p>