I need run this code when the file is opening:
Any idea?![]()
Sub Remove_Formula_Errors() Dim rng As Range, cell As Range, fmla As String Set rng = Cells.SpecialCells(xlCellTypeFormulas, 16) For Each cell In rng fmla = Right(cell.Formula, Len(cell.Formula) - 1) cell.Formula = "=if(iserror(" & fmla & "), """"," & fmla & ")" Next End Sub
Thanks
Bookmarks