I have a program and I saw some of the cells having "#N/A"

I wish to have excel delete its cell content if encounter this value.
eg. If activecell.value = "#N/A".

However, excel gave me a "type mismatch" error.

How can I overcome this?

Please help. Thanks.