Integrating leave blank cell if error into existing code

Hey all,

I need help to integrate 'make cell blank if there is an error' into my existing code.

Currently, when I get an error, the macro will use the cell value of the most recent non-error cell. What happens is that I will get duplicate entries for all my error cells, until a non-error text is read.

Anyone knows how to integrate the leave blank cell if error into my existing code?

Code:

Please Login or Register  to view this content.