根据列标题中的错误删除所有列？

I use index match or hlookup a lot to make sure I get only the columns I want for a certain file. Whatever I cannot match, I need to delete. What is the most efficient VBA script to remove all column headers of "#N/A"?I use index match or hlookup a lot to make sure