VBA - if cell contains #N/A then

[wmc5880]

Been trying to figure this one out for a while.. Does anyone have a good suggestion?

Just want to loop down the sheet and find/change "#N/A"

If #N/A then.. Problem is that i get an error if the cell contains a value other than N/A.
Maybe there is a formula is not integer?

For e = 2 To finalRow            
            If Cells(e, 10).Value = CVErr(xlErrNA) Then
                Cells(e, 10).FormulaArray = IndexMatch
                Cells(e, 11).FormulaR1C1 = "=RC[-1]*RC[-3]"
            End If
Next e

 

[VBA Geek]

if application.isna(cells(e,10)) then

....

end if


</pre>