Here's some tested VBA code that may work for you:

On Error Resume Next
ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas, 16).Select
For Each c In Selection
If c.Text = "#N/A" Then c.Value = ""
Next c

- David

David Hilberg wrote:
Since Excel has Goto/Special/Formulas/Errors, you could record a macro
to get you that far, then test each cell in the selection for "#N/A".

- David

NewToVB wrote:
I need to look at every cell in the sheet and if it has "#N/A" then I
need to replace it with "" .