| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel "name is not valid" when naming a cell
I am programmatically naming cells based on a header row and their
position. The problem is not in code but in a name I am trying to use. I am trying to name a cell 'C2a.1' and I get 'That Name is not Valid'. When doing this manually I get the same error. Looking at the help I know I can't name a cell or range like a valid Excel reference e.g. A2 or $A$2 or R1C2 etc... but this is a mystery to me! Any ideas? Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
| =IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Naming cell ranges, copying formulas for a range & nesting "IF" fu | Excel Discussion (Misc queries) | |||
| Why is "History" a "reserved name" while naming Excel worksheets? | Excel Discussion (Misc queries) | |||
Threaded Mode
