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

Sorry this is old news. Be sure to select a range where the top left cell contains an error. Then you get the yellow pop up needed to "Ignore Error"...so helpful!

An inline option that worked for me, and was a bit simpler:

In my example the error was in bite 4, so that's what I used, but it could be on any bite: 1 - 7

Worksheets.Item(strSheet).Range(strColumn & strRow & ":" & strColumn & strRow).Errors(4).Ignore = True