View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default Defining cell name / giving multiple cells a name

Hi,

C and R are already reserved for select an entire Column or Row containing
the active cell when typed into the name box.

Regards!
Jean-Guy

"ducmis" wrote:

I want to name cells A1:A3 to "C". Excel doesn't allow me to do this. Can
anyone please help me with this area.

I am able to name it to "A" or "B" but not "C". I am using the indirect
function to cascade my drop down list.
--
Duc Tran