define a name dinamically

[Sharro]

How can I dinamically define the name for a range according to the text of a
cell.

Meaning, if I change the text on that the cell, the range name will also
change.

Thanks for any help.

All the best,

 

[JulieD]

Hi Sharro

bit confused here ... do you want to change the name of the range i.e. i
have the range A1:A10 and it's called "AAA" and when you put 2 in B1 you
want the name of the range to change to "BBB" .. if so i don't think this is
possible without code

OR
do you want to put the name of a range in B1 and use that range in another
formula, say in C1, e.g. if B1 you type AAA and in C1 the number of items in
the range A1:A10 is counted or if you type BBB in B1 the number of items in
the range A11:A20 is counted ... if this is the case then the INDIRECT
function should give you want you're after e.g.
=COUNTA(INDIRECT(B1))

you can use INDIRECT in pretty much any formula ..

Hope this helps
Cheers
JulieD