Try something like this...

Sheet1.Cells.SpecialCells(xlCellTypeFormulas).Clea rContents

which clears all of the formulas on sheet 1
--
HTH...

Jim Thomlinson


"Souris" wrote:

I wanted to clear all the cells which have formula on it.
Are there any function to check this like "Isformula" in VBA?

Any information is great appreciated,