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

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