gformula to find formulas

  • Thread starter Thread starter gary
  • Start date Start date
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.
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
HELP!!! I can't set formula to cell 1
Insert Row also adds formulas and moves cursor 2
Formula appearing as Value in Formula Bar 1
Runtime error 1004 when trying to insert formula in cells 11
Column number of last column that returns value ignore formulas 8
Named Range maker code 9
Mid column sum formulas with varied ranges to sum 17

Back
Top