| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to reference existing functions in a custom function: possibl | Excel Worksheet Functions | |||
| custom functions stop working in PivotTable in Excel2003 | Excel Discussion (Misc queries) | |||
| Custom Format and Data Validation Q | Excel Worksheet Functions | |||
| Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
