I have a formula which gives a #n/a in the cell :
=VLOOKUP(A1,B14:C29,2,FALSE)

In order not to show #n/a, I've edited the cell and changed it to:
=IF(ISERROR(VLOOKUP(A1,B14:C29,2,FALSE)),0,VLOOKUP (A1,B14:C29,2,FALSE))

Is there a way to create a macro so that I don't have to edit the
formula every time. In other words, the macro will do all the editing
for me.

Thanks in advance for your help!


--
Tang123
------------------------------------------------------------------------
Tang123's Profile: http://www.excelforum.com/member.php...o&userid=27846
View this thread: http://www.excelforum.com/showthread...hreadid=473577