ShowErrors Method [Excel 2003 VBA Language Reference]

Draws tracer arrows through the precedents tree to the cell that's the source of the error, and returns the range that contains that cell.

expression**.ShowErrors**

expression Required. An expression that returns a Range object.

Example

This example displays a red tracer arrow if there's an error in the active cell on Sheet1.

Worksheets("Sheet1").Activate
If IsError(ActiveCell.Value) Then
    ActiveCell.ShowErrors
End If

Applies to | Range Collection

See Also | ClearArrows Method | ShowDependents Method | ShowPrecedents Method