I have a spreadsheet that has some error triangles for inconsistent formulas. They are not: if they were I would fix them, lol.
I know how to run a macro to turn them off:
Code: Select all
Sub clearInconsistent()
Dim c As Range
For Each c In ActiveSheet.UsedRange.Cells
If c.Errors(xlInconsistentFormula).Value Then c.Errors(xlInconsistentFormula).Ignore = True
Next c
End Sub
I want to do something like that in the code that creates the formulas, but c.Errors(xlInconsistentFormula).Value is always false until the macro stops running. Is there someway in VBA to get Excel to turn on the error triangles? I was hoping Application.Calculate would do it, but it doesn't
Just trying to avoid running two macros. Thanks!