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()...