To apply iferror function in multiple formulated cells in excel is a quite hectic task. It consumes lot of hours to apply iferror function on thousand of cells. But, by using below code this task can be finish in only couple of minutes.

Here is the code which will help you to apply iferror function on selected ranges.

Sub Apply_IFERROR_On_Selection()

'

' Author: Dreams24

' Written for VBA Tricks and tips blog

' https://www.vbatricksntips.com

Dim myCell As Range

For Each myCell In Selection.Cells

If myCell.HasFormula And Not myCell.HasArray Then

myCell.Formula = "=IFERROR(" & Right(myCell.Formula, Len(myCell.Formula) _ 1) & ",0)"

End If

Next

MsgBox "Task Finished. check your cells to validate formula..", vbInformation, Title:="Iferror Function"

End Sub