Yes, simply returning a TRUE or FALSE occurred to me. But
if you're sharing the worksheet with others, such as a
boss, it's more time-consuming to explain TRUE or FALSE
then "Formula" and "".
-----Original Message-----
Jason Morin wrote...
You can't do it directly with a worksheet formula, but a
simple UDF would work. Something like:
Function IsFormula(Cell As Range) As String
If Cell.HasFormula = True Then
IsFormula = "Formula"
Else
IsFormula = ""
End If
End Function
....
Obtuse! The OP wants to do something other than show
Formula or not.
Didn't occur to you just to return the value of the
range's .HasFormula
property?
.
|