If Worksheetfunction.isna(c.value) = False Then

End If

If this post helps click Yes
---------------
Jacob Skaria


"Ryan" wrote:

I have code in my spreadshhet that goes through a range of cells and if they
are not blank it holds the value and not the formula:

If c.value < "" then c.value = c.value
Next

This works perfectly however I have changed my formula in the spreadsheet to
show #N/A instead of "". How do I convert this in the code to say - "if the
cell value is not #N/A then c.value = c.value"?