how to Ignore formula Error Checking?

**dlh** · 07-18-2008, 01:18 PM

Thank you, colin_l. I've tested that and it doesn't work either.

I think it's equivalent to the code I posted.

**Colin Legg** · 07-18-2008, 01:37 PM

Hi dlh,

I apologise for not reading your question closely enough.

Revised answer:

myCell.Errors(xlOmittedCells).Ignore = True

Regards,
Colin

**dlh** · 07-18-2008, 01:58 PM

colin_l, I really appreciate your help.

Sorry, that's not it either.

Enclosed is a sample workbook. Change the cell that contains "YEAR" to "2008" and the green triangle appears.

**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