TRACER.ERROR

Macro Sheets Only

Equivalent to clicking the Tracer 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

List of Command-Equivalent Functions