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"
i have been given the following code, but VB keeps erroring on it -
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
Selection.FormulaR1C1 = "0"