View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default 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!