gformula to find formulas

G

gary

I need a formula that references another cell and tells me
whether that cell has a formula or a value in it.
Any ideas??
Thanks.
 
F

Frank Kabel

Hi
you may try the following UDF (put in a module of your workbook)

Function is_formula(rng As Range)
is_formula = rng.HasFormula
End Function

Now enter the following in A2 to check A1:
=IF(is_formula(A1),"A1 is a formula","A1 is a value")
 
Top