This user defined function will return true or false.

Function IsFormula(cell)
IsFormula = cell.HasFormula
End Function

Usage is: =IsFormula(cellref)


Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 07:30:05 -0700, txtxyeha
wrote:

Is there a formula that distinguishes if a cell contains a number as a result
of a formula or data that has been directly input (i.e., formula
overwritten)?