View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Using custom functions within custom validation

You need to refer to it indirectly, you can put it away somewhere not
normally visible like in IV1 then refer to IV1 or create a defined name
and refer to that name



--

Regards,

Peo Sjoblom

"Neil" wrote in message
...
When creating a custom validation rule using DATA-VALIDATION-CUSTOM menu,

is
it possible to use a custom function that I have written?

E.g. =customfunc(A1)=true

Whenever I try this I get the error "A named range you specified cannot

be
found". Presumably it is referring to the custom function name? Surely it

is
possible?

Thanks for any help with this.

Neil