Sub InsertIFERROR()
*** Dim R As Range
*** For Each R In Selection.SpecialCells(xlCellTypeFormulas)
******* R.Formula = "=IFERROR(" & Mid(R.Formula, 2) & ",""0"")"
*** Next R
End Sub
Sub InsertIFERROR()
*** Dim R As Range
*** For Each R In Selection.SpecialCells(xlCellTypeFormulas)
******* R.Formula = "=IFERROR(" & Mid(R.Formula, 2) & ",""0"")"
*** Next R
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks