Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is excel iptc compatible | Excel Discussion (Misc queries) | |||
OFFICE XP COMPATIBLE WITH VISTA | Excel Discussion (Misc queries) | |||
Compatible versions of excel | Excel Discussion (Misc queries) | |||
SPSS compatible format | Excel Discussion (Misc queries) | |||
Is Excel 2000 compatible with Windows 98 and or ME? | Excel Discussion (Misc queries) |