How to get the name of a range i deternimed
 

hi,

i mane a range ,for example, gggg, and i want to get the name "gggg"
through

vba,what should i do.

thank you.

How to get the name of a range i deternimed
 

Range("gggg").Select
msgbox activeCell.Name.Name

--
Regards,
Tom Ogilvy


"EXCEL$B!!(BNEWS" wrote in message
...
hi,

i mane a range ,for example, gggg, and i want to get the name "gggg"
through

vba,what should i do.

thank you.

How to get the name of a range i deternimed
 

?Range("C8:E13").Name.Name
gggg


"EXCEL$B!!(BNEWS" wrote in message
...
hi,

i mane a range ,for example, gggg, and i want to get the name "gggg"
through

vba,what should i do.

thank you.

How to get the name of a range i deternimed
 

hi, Tom and Vasant
Thanks for your advice.

but why it is name.name ,not names.name

thanks

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
?Range("C8:E13").Name.Name
gggg


"EXCEL$B!!(BNEWS" wrote in message
...
hi,

i mane a range ,for example, gggg, and i want to get the name "gggg"
through

vba,what should i do.

thank you.

How to get the name of a range i deternimed
 

While a range can have more than one name, you can only retrieve one of them
through the range object. So, that appears to be just the way they designed
it.

--
Regards,
Tom Ogilvy



"EXCEL$B!!(BNEWS" wrote in message
...
hi, Tom and Vasant
Thanks for your advice.

but why it is name.name ,not names.name

thanks

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
?Range("C8:E13").Name.Name
gggg


"EXCEL$B!!(BNEWS" wrote in message
...
hi,

i mane a range ,for example, gggg, and i want to get the name "gggg"
through

vba,what should i do.

thank you.