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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • MicheleDavidson
    New Member
    • Mar 2010
    • 7
    #1

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

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

    Thanks.
    Tags: None
    • SammyB
      Recognized Expert Contributor
      • Mar 2007
      • 807
      #2
      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.

        Comment

        Previous template Next
        Working...