G gary Feb 27, 2004 #1 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.
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 Feb 27, 2004 #2 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")
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")
