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 returns #VALUE! when regional language setting not English!?

What's the code of your UDF and how exactly do you call it? With what values?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Andrew Wiles" wrote in message ...
|I have an automation add-in which works fine on my UK English configuration.
| If I change the regional language settings in the control panel to Danish the
| UDF fails and returns #VALUE!.
|
| I have simplified this problem down to the point where the UDF is simply
| returning a string so the problem cannot (I think) be in the UDF processing.
|
| I am somewhat stumped as to where to go to resolve this problem.
|
| Any thoughts?
|
| Configuration is Excel 2007 on Vista x64