Just need some clue as to how to identify the SUM formula using VB. I tried the following, of no use:
If Not cell.HasFormula And Not cell.Formula Like "=sum(" Then
The idea being, I want to retain the SUM formula in a range of cells and delete if it has some text or other formulas.
Any help would be appreciated.