Steve,

I have just recreated it and it works fine.

Did you put =IsFormula(A1) in the formula box, that is with the equals sign?
When I just entered IsFormula(A1) it changed it to ="IsFormula(A1)". Is
this what you mean?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"steveh" wrote in message
...
I have this defined as a module...

Function IsFormula(cell)
Application.Volatile
IsFormula = cell.HasFormula
End Function

The file was created in xl03 and saved as a xl2000. I am using the UDF
for conditional formatting and when I put in isformula(A1) it doesnt work
and when I go back to CF there is " " the formula. What am I doing wrong?

Thanks
Steve