Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation question
hi gurus
I have defined a Name for a function, WS_Name, that returns the name of the active worksheet (eg A6-X, A4-R, B7-Q ...etc). On each worksheet, I want to add validation to column C. The value in colum C must be =MID(WS_Name,2,1). In the 3 sheets mentioned above, column C should accept ONLY values of 6, 4 and 7 respectively. I can't get the validation to work. I'm trying ... DataValidationSettings Allow: Custom, Formula: =MID(WS_Name,2,1) or DataValidationSettings Allow: Custom, Formula: =VALUE(MID(WS_Name,2,1)) No luck so far. Column C still takes any value. Any ideas? TQ, Anny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation question | New Users to Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
Another Exciting Data Table Question!!!! | Charts and Charting in Excel | |||
DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) | Excel Discussion (Misc queries) |