ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Defining cell name / giving multiple cells a name (https://www.excelbanter.com/excel-discussion-misc-queries/133958-defining-cell-name-giving-multiple-cells-name.html)

ducmis

Defining cell name / giving multiple cells a name
 
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

pinmaster

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



All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com