VBA - Replace #Value! with empty cell

Hello to you,

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

For NULL cells, I use the Selection.Replace() function, which works relatively well. However, for all data beginning with #, the REPLACE function doesn't seem to identify them. If I do it manually with SEARCH&REPLACE, it works fine, but I don't see why the macro can't do it automatically. I have filtered the database for the history, but the macro is intended for new data.

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

Thank you, Mat

Configuration: Windows / Chrome 58.0.3029.110