Indirect Method for Name Box Variable?

[Chris Brennan]

Can the name box use the Indirect method for defining its name?

I wish to use a cell's value to define the name in the name box. I'
not sure if this is possible or if I'm just getting the syntax wrong.
I'm trying to group 7 days (cells) and then have Excel keep th
grouping as I copy them for subsequent weeks. I don't want to manuall
keep naming the groups as new weeks are added.

Example in the name box:
INDIRECT("week" & $A1)

where A1, A2, A3, etc. will contain the sequencial values 1, 2, 3, etc

Essentially, the names would end up being week1, week2, week3, etc.


I've just managed to Indirect much of the other functions of m
workbook and this seems to be the last part to fix.

Thanks,
Chris Brenna

 

[Bob Phillips]

Don't think you can do what you want. You can create names that use a cell
in it's ReferTo value, but not in the name.

 

[Frank Kabel]

Hi
I agree with Bob that this is not possible. Question: Why do you want
to do this?