Hide "inconsistent formula" error in a selection in Excel

You can do this for a range by:

1. selecting the range.
2. Click the arrow next to the button that appears.
3. Select ignore error

Opton 2 via vba: select your cells and run the following macro

Sub Example() 

    Dim rngCell As Range, bError As Byte 
    For Each rngCell In Selection.Cells 

        For bError = 1 To 7 Step 1 

            With rngCell 
                If .Errors(bError).Value Then 
                    .Errors(bError).Ignore = True
                End If 
            End With         
        Next bError     
    Next rngCell 

End Sub