Thread: Indirect Name

Name it

_C

you can't use a named range that looks like a cell reference (you can't use
A1, or R either as examples).

--
Regards,
Tom Ogilvy


"SanctifiedRock" wrote:

>
> 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
>
>