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.
Syntax
expression.ShowErrors
expression A variable that represents a Range object.
Return value
Variant
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