Range.ShowErrors Method (Excel)

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 A variable that represents a Range object.

Return Value

Variant

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
Show: