Hi Steve,

You posted this question on Jan 16. On Jan 17 Dave Peterson asked you some
further details. As far as I can see, you did not reply, but posted the same
question again in another thread, which is not very respectful to those who
took the trouble to try and solve your problem.
Sorry if I'm mistaking.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"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