Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |