如何删除工作表中显示的#N / A？ （需要VBA for excel）

I have to clear #N/A that happens through out my worksheet when ever i run my code. I'm not sure why and have been debugging for a while but to no avail. What i could do to remedy this problem is to delete it entirely from the page, where they happens randomly. If anyone know how to, do share a VBA code with me.I have to clear #N/A that happens through out m