Macro needed for MS Excel to change "#VALUE!" text into $0.00 integer

[MicheleDavidson]

Hi, I need a VB Macro for MS Excel to change "#VALUE!" text into $0.00 integer in columns E&F only.

Thanks.

[SammyB]

I don't think that you really want a macro. That would wipe out the formula, then if the data changed, you'd want the formula back. Just wrap the formulas in E and F with an IFERROR function.

For example, if E1 contains =SUM(A1:C1)
then change the formula to =IFERROR(SUM(A1:C1),0)

Then just auto-fill the rest of the rows.