|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com