#N/A retruning in MATCH formula cell - need to change to 0

[Mew22]

i have a long match formula that is returnin #N/A when there is not matching data, i want to turn the #N/A to 0 (zero), can any one help?

i have been given the following code, but VB keeps erroring on it -

Selection.SpecialCells(xlCellTypeFormulas, 16).Select
Selection.FormulaR1C1 = "0"

 

[VoG]

Perhaps

Selection.SpecialCells(xlCellTypeFormulas, xlErrors).Value = 0

 

[Mew22]

thanks heaps! worked like a treat!