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

--
Hunter197
-----------------------------------------------------------------------
Hunter1978's Profile: http://www.excelforum.com/member.php...fo&userid=3726
View this thread: http://www.excelforum.com/showthread.php?threadid=56978