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