Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Identifies all the cells that contain formulas resulting in errors in the active worksheet
Sub fomulaCell()
    ActiveSheet.Cells.SpecialCells(Type:=xlCellTypeFormulas, _
        Value:=xlErrors).Activate
End Sub