Sub HighlightErrors() Selection.SpecialCells(xlCellTypeFormulas, xlErrors).Select Selection.Interior.Color = vbRed End Sub