Iferror return 0 for worksheet VBA

This is my first post to the forum so bare with me. I have a pretty extensive workbook with thousands of references. My boss would like me to make a consolidated list of GP, Profit, Expenses for all items but in doing so easily I would need to remove all "#N/A" cells without compromising the integrity of such cell formulas. AKA I don't just want to clear the cells that return "#N/A"s but rather start each formula with an =IFERROR(cell,0). Can someone please help me write a VBA code that will take each cell on a selected WORKSHEET and insert an IFERROR return "0"? It is important that the VBA only works on selected worksheets since I don't want my whole workbook overwrited with IFERROR statements.

Thank you,