On Thu, 30 Mar 2006 16:35:36 -0600, DougVba
wrote:


::I am trying to detect cells that have the InconsistentFormula error
and if possible get each cell location.

After our administrator runs a setup macro, I want to remind her to
look at any cells that have formula errors.::

In a macro

With ActiveSheet
Range(Range("A1"),
Range("A1").SpecialCells(xlCellTypeLastCell)).Spec ialCells(xlCellTypeFormulas,
16).Select

End With


Alternatively F5 (Goto), Special-- Formulas and select the Errors
checkbox, deselecting the other three.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________