I am trying to test a list of named cells to determine if they contain formulas or text values.
Can anyone help me write a macro to do this.
My attempt at this returned a type mismatch error.
If ActiveCell.Type.xlCellTypeFormulas Then
ActiveCell.FormulaR1C1 = "Formula"
ActiveCell.FormulaR1C1 = "Not a Formula"