Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Highlight formulas
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Why won't formulas obey vertical alignment commands? | Excel Discussion (Misc queries) | |||
Tricky formulas needed | Excel Worksheet Functions |