ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UDF 2000 compatible? (https://www.excelbanter.com/excel-programming/288810-re-udf-2000-compatible.html)

Niek Otten

UDF 2000 compatible?
 
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





All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com