Replacing data using the cell value not the formula

[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

 

[NickHK]

Why not include it in your formula:
=If(ISNA(<YourFormula>),0,<YourFormula>)

NickHK

 

[Hunter1978]

Hi NickHK,

Thanks for your answer.

It seemd to have done the trick!

Many thanks