Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range Name C
I am using Data/Validation/List to display a list based on what is entered in another cell. using the formula: INDIRECT({Cell Reference}). My problem is one of my needed Named Ranges should be "C" but whenever I try to use it I get an error message. Any Ideas how to fix this? -- SanctifiedRock ------------------------------------------------------------------------ SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485 View this thread: http://www.excelforum.com/showthread...hreadid=542526 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range Name C
Excel probably is getting confused with cell references. Use a different
name, differentiating form cell addresses. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "SanctifiedRock" <SanctifiedRock.27wnlc_1147791003.7624@excelforu m-nospam.com wrote in message news:SanctifiedRock.27wnlc_1147791003.7624@excelfo rum-nospam.com... I am using Data/Validation/List to display a list based on what is entered in another cell. using the formula: INDIRECT({Cell Reference}). My problem is one of my needed Named Ranges should be "C" but whenever I try to use it I get an error message. Any Ideas how to fix this? -- SanctifiedRock ------------------------------------------------------------------------ SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485 View this thread: http://www.excelforum.com/showthread...hreadid=542526 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range Name C
"C" and "R" are not valid names because they would get confused with L1C1
notation HTH -- AP "Bob Phillips" a écrit dans le message de news: ... Excel probably is getting confused with cell references. Use a different name, differentiating form cell addresses. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "SanctifiedRock" <SanctifiedRock.27wnlc_1147791003.7624@excelforu m-nospam.com wrote in message news:SanctifiedRock.27wnlc_1147791003.7624@excelfo rum-nospam.com... I am using Data/Validation/List to display a list based on what is entered in another cell. using the formula: INDIRECT({Cell Reference}). My problem is one of my needed Named Ranges should be "C" but whenever I try to use it I get an error message. Any Ideas how to fix this? -- SanctifiedRock ------------------------------------------------------------------------ SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485 View this thread: http://www.excelforum.com/showthread...hreadid=542526 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range Name C
R1C1 in English <g
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Ardus Petus" wrote in message ... "C" and "R" are not valid names because they would get confused with L1C1 notation HTH -- AP "Bob Phillips" a écrit dans le message de news: ... Excel probably is getting confused with cell references. Use a different name, differentiating form cell addresses. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "SanctifiedRock" <SanctifiedRock.27wnlc_1147791003.7624@excelforu m-nospam.com wrote in message news:SanctifiedRock.27wnlc_1147791003.7624@excelfo rum-nospam.com... I am using Data/Validation/List to display a list based on what is entered in another cell. using the formula: INDIRECT({Cell Reference}). My problem is one of my needed Named Ranges should be "C" but whenever I try to use it I get an error message. Any Ideas how to fix this? -- SanctifiedRock ------------------------------------------------------------------------ SanctifiedRock's Profile: http://www.excelforum.com/member.php...o&userid=34485 View this thread: http://www.excelforum.com/showthread...hreadid=542526 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
can a formula check for a certain value in a range? | Excel Discussion (Misc queries) |