Posted to microsoft.public.excel.misc
|
|
Function to detemine whether function or value in cell
What is the function?
"Bob Phillips" wrote:
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
|