XL97: Cannot Use Custom Function with Data ValidationLast reviewed: March 13, 1998Article ID: Q160523 |
The information in this article applies to:
SYMPTOMSWhen you use custom criteria with data validation and attempt to type a custom function in the Formula box in the Data Validation dialog box, the following message appears:
A named range you specified cannot be found. CAUSEThis behavior occurs when the following conditions are met:
WORKAROUNDTo work around this behavior, type the custom function in a cell on the worksheet, and then type a formula that refers to this cell in the Formula box. For example, type the custom function in cell A1, and then type "=A1" (without the quotation marks) in the Formula box in the Data Validation dialog box.
STATUSThis behavior is by design of Microsoft Excel 97 for Windows.
MORE INFORMATIONThe Custom data validation criteria type allows you to type a formula, use an expression, or refer to a calculation in another cell to determine a valid entry. When you type a formula, the formula must evaluate to True or False. For additional information about data validation, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q159252 TITLE : XL97: Description and Examples of Data Validation REFERENCESFor more information about data validation data types, click the Index tab in Microsoft Excel Help, type the following text
Data Validation, Data Typeand then double-click the selected text to go to the "Types of data restrictions" topic.
|
Additional query words: XL97 8.00
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |