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
Function ContainsFormula(a As Range) As Boolean
ContainsFormula = a.HasFormula
> 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.