Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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