how to Ignore formula Error Checking?

I find Excel's "helpful" suggestions for fixing formulas very annoying and I turn them off. But users of my workbook may not have done that.

My code makes changes to the sheet in a way that triggers one of Excel's suggested corrections. It says "Formula Omits Adjacent Cells." I can manually tell it to ignore the error in this cell (making the green triangle in the upper left corner disappear).

But how can I do this in my code? I tried recording a macro but when I clicked ignore nothing was captured.

I've also tried the following:

MyCell.Errors(xlInconsistentFormula).Ignore = True

This either doesn't work or I can't find the right xlErrors constant.

Suggestions?

Hi dlh,

I apologise for not reading your question closely enough.

Revised answer:

myCell.Errors(xlOmittedCells).Ignore = True

Regards,
Colin

Strange.... I opened your workbook, changed the cell D2 to 2008 per your instruction and then the "green triangle" appeared in cell B2. Then I ran the code I supplied previously and the error disappeared as suggested....

Sub foo()
    Dim rngCell As Range
    
    Set rngCell = Worksheets("Sheet1").Range("B2")
    rngCell.Errors(xlOmittedCells).Ignore = True
    
End Sub

I suppose this could feasibly be an Excel version discrepancy... I am using Excel XP.

Colin