how to Ignore formula Error Checking?

**Colin Legg** · 07-18-2008, 02:05 PM

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