Cell content = formula or concrete number?

Isnumber will check for both a numeric value and a formula which results in

a numeric value.

The following VBA function results in TRUE only for a formula, as you can

easily test.

Function ContainsFormula(a As Range) As Boolean

ContainsFormula = a.HasFormula

End Function

Regards,

Niek Otten

Quote:

> Does Excel offer an information function which takes the value "true" if

> a certain cell content equals a concrete number (e.g.:9384398) and the

> value "false" if the content of this cell equals a formula

> (e.g.:h120+k120) or vice versa? All available information functions do

> not help - as far as I see.

> Any information on this topic would be of great help!

> Thanks a lot!

> Sent via Deja.com http://www.deja.com/

> Before you buy.