Range.ShowErrors (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.

Dim booShowErrors As Boolean
booShowErrors = ActiveCell.ShowErrors