Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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=542522 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
INDIRECT.EXT | Excel Discussion (Misc queries) | |||
Help with INDIRECT | Excel Worksheet Functions | |||
#REF using =INDIRECT... | Excel Worksheet Functions |