| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Range.ShowErrors method (Excel) |
vbaxl10.chm144197 |
|
|
02366ef0-b4dc-a10c-e186-d9392a8b656c |
05/11/2019 |
medium |
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.
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[!includeSupport and feedback]