Hi
not without using VBA. You may use a UDF such as
public function is_formula(rng as range) as boolean
is_formula=rng.hasformula
end function
--
Regards
Frank Kabel
Frankfurt, Germany
"Philip Reece-Heal" schrieb im
Newsbeitrag . ..
Does anyone know of a function that can identify if a cell has a
formula in
it, as opposed to a number or text.
Any help appreciated
Philip
|