Replacing data using the cell value not the formula

  • Thread starter Thread starter Hunter1978
  • Start date Start date
H

Hunter1978

Hi all,

I'm trying to replace data in a cell range using the cell's valu
instead of it using the formula.

I'm using the following code:-

ActiveSheet.Range("I:I").Select
Selection.Replace What:="#N/A", Replacement:="0"
LookAt:=xlPart, LookIn:=xlValues, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False
_
ReplaceFormat:=False

However, when I run the macro it errors at this point.

Basically, I'm trying to remove the dreaded #N/A and replace it with
0. Is there an easier way of doing this??

Thanks
 
Back
Top