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?
Bookmarks