Non-Consistent Formulas

[Shay A]

Hi,
A code to loop through all cells containing such formulas amd will ignore Excel's warning.

Thank you!

 

[PCosta87]

Hi,
A code to loop through all cells containing such formulas amd will ignore Excel's warning.

Thank you!

Hi @Shay A

Here you go:

Sub ignore()

    Dim c As Range
    Dim rng As Range
    Set rng = ActiveSheet.UsedRange.Cells.SpecialCells(xlCellTypeFormulas)
   
    For Each c In rng
        c.Errors(xlInconsistentFormula).ignore = True
    Next c

End Sub

Regards