View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default UDF is not executing

Please post the code of your UDF, the formula with which it is called *and* the values of the arguments. Please check the types of
the arguments (ISTEXT(), ISNUMBER(), .....)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Chris" wrote in message ...
|I have an custom add-in that has a number of subroutines and UDFs. The
| subroutines seem to run fine, but some UDFs are returning #VALUE.
|
| At first I thought it was an error in the program so I set a break point on
| the first line of code in the function to determine what the error might
| be... however the code isn't making it there.
|
| If I change the name of the function by adding an "a" to the front it works
| fine.
|
| Please help -- I have no idea where the conflict is.
|
| Thanks in advance,