Solved: macro to replace error formula cells in a column with some other text or number.

[abhay_547]

Hi All,

I need a macro which which will search for the rows from a column which contain error in formulas and then replace that cell with some text like No value or a Number like zero.

Thanks for your help in advance. :bow:

[mbarron]

Change the range to suit your needs.

With Range("D:D")
.SpecialCells(xlCellTypeFormulas, 16).Value = "Your replacement"
End With

[abhay_547]

Hi mbarron,

Thanks a lot. It's working now. That was exactly want I wanted.