W
wammer
Is there a function that will tell me whether or not a cell is a type
value or a formula
value or a formula
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
hgrove
wammer wrote...
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]
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]
F
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
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
G
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
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