whey not just return true or false for a function?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Billy Liddel" wrote in message
...


"nc" wrote:

Is there a function in Excel 2003 which can return info. on whether a
cell
contains a function or a value?

You could use this UDF

Function isFormula(x) As String
If x.HasFormula Then
isFormula = "Has Formula"
Else
isFormula = "Has Value"
End If
End Function

Copy this into a VB Module and use as normal function. If you want to use
this in all your workbooks copy it into a module in a new blank book and
save
it as Personal.

Regards
Peter