Equivalent to clicking the Trace Error button on the Auditing toolbar on a worksheet. Allow tracer arrows to be graphically displayed showing which cells are generating an error value.
Syntax
TRACER.ERROR()
Returns TRUE if Microsoft Excel successfully found the cell at which the error occurred. Returns FALSE if an error is not found.
Remark
Returns the #VALUE! error value if not available; for example, the selection is something other than worksheet, or cell(s) that cannot be traced.
If you need to know if there is an error in a cell, use ISERROR().
Related Functions
TRACER.DISPLAY Allows tracer arrow to be displayed
TRACER.CLEAR Clears all tracer arrows on the worksheet
Return to index