| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
gformula to find formulas
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
gformula to find formulas
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") -- Regards Frank Kabel Frankfurt, Germany gary wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Cells that do not have Formulas in them. | Excel Worksheet Functions | |||
| Can you please hel me to find the correct formulas | Excel Worksheet Functions | |||
| where can I find help with excel formulas? | Excel Discussion (Misc queries) | |||
| I NEED TO FIND TWO FORMULAS | Excel Worksheet Functions | |||
| How find all formulas on tab? | Excel Programming | |||
Linear Mode
