UDF 2000 compatible?
 

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

UDF 2000 compatible?
 

When I open I get a failure msg then when I clear that off the VBA editor opens up. WHen I go to the isformula module, the firstline is highlighted. Cut/pasted from module... Function IsFormula(cell) If I comment out the whole module, the file opens fine.