need to check whether cell contains formula

[etodem]

Is there any formula (or combination thereof) that says whether a cell contains a formula or not?


specifically i want to distinguish a cell with, for example, =A3*C4, from a cell with just a value, say 13.8

[ConneXionLost]

Here's a UDF that will do what you ask:

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

Cheers,

[MWE]

Originally Posted by etodem

Is there any formula (or combination thereof) that says whether a cell contains a formula or not?
specifically i want to distinguish a cell with, for example, =A3*C4, from a cell with just a value, say 13.8

Do you want a macro to do this? If so, this is pretty easy.