Formula versus value

[wammer]

Is there a function that will tell me whether or not a cell is a type
value or a formula

 

[hgrove]

wammer wrote...

Is there a function that will tell me whether or not a cell is a
typed value or a formula?

There's no built-in function that does so, but you could use defined
names calling XLM functions or use user-defined functions (udfs)
written in VBA. This was discussed yesterday.

http://www.google.com/[email protected]

 

[Frank Kabel]

Hi
1. create a custom function in VBA. e.g.
public function is_formula(rng as range)
is_formula=rng.hasformula
end function

2. Use the following formula
=IS_FORMULA(A1)
for cell A1

 

[Gord Dibben]

wammer

No built-in function.

User defined function.....

Function IsFormula(Cell)
Application.Volatile
IsFormula = Cell.HasFormula
End Function

Copy/paste to a general module in your workbook

Usage is: =ISFORMULA(A1)

Alternative if you just want to find which cells have formulas..........

Select a range of cells and F5>Special>Formulas>OK

Gord Dibben Excel MVP