Formula to Determine if Cell Value is from a Keyed Value or a Form
Not directly. You can find formulas/constants with the Go-to dialogue
(Ctrl+G, special) for a quick search, or you can use a UDF like this:
Function IsFormula(r As Range) As Boolean
If r.Value = r.Formula Then
IsFormula = False
Else
IsFormula = True
End If
End Function
--
Best Regards,
Luke M
"JG" wrote in message
...
Is there a formula that can tell me whether a cell's value is a keyed
value
(probably a number, if that helps) or if it was determined via a formula.
What I'm doing: I'm building an estimation tool and I want to identify
where manual tweaks have been made (don't want to do protection here).
Thanks!
|