| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of cell range not accepted in Conditional Validation
When I name a range of cells by InsertNameCreateTop Row and the cell value
in the top row is: "Wrenches, 1/2" square" etc., the name is automatically changed to "wrenched_1_2__square" and so on. It is not identical to the cell / column heading. When I then use ValidationList=Wrenches, 1/2" square, the list can not be found. When I rename the cell with no spaces or odd signs, it works. Is there a way around the renaming? I would like to keep the signs like / & " # in the cell range name. -- Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Names of workbook cell ranges not accepted with some signs | Excel Worksheet Functions | |||
| No. of digits accepted in one cell | Excel Worksheet Functions | |||
| Inconsistency in how Range object is accepted? | Excel Programming | |||
| Conditional data validation (using a filtered range?) | Excel Worksheet Functions | |||
Threaded Mode
