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 "" .