VBA - Reemplazar #¡VALOR! por celda vacía

Hello to you,

Inside an existing database, I’m trying to add a VBA macro to replace the contents of NULL, #VALUE!, #N/A cells with an empty cell. I’m still trying to grasp the basics in VBA...

For NULL cells, I use the Selection.Replace() function which works fairly well. However, for all data starting with #, the REPLACE function does not seem to identify them. If I do it manually it works well with SEARCH&REPLACE, but I don’t see why the macro doesn’t allow it automatically. I have therefore filtered the database for history, but the macro is for the new data.

I tried using the ISERROR function, but I don’t master it.

Thanks Mat

Configuration: Windows / Chrome 58.0.3029.110