Thread: Indirect Name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SanctifiedRock[_3_] SanctifiedRock[_3_] is offline
external usenet poster
 
Posts: 1
Default Indirect Name


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