View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
fedude fedude is offline
external usenet poster
 
Posts: 74
Default Check for #NA in VB?

ISNA() is not available as a worksheet function in VB.

"IanKR" wrote:

Is there a way I can check to see if a cells formula resolves to #NA. It
doesn't appear that ISNA or NA() are available in excel vb


use WorksheetFunction.IsNA()...