Extract Name from Range

[Guest]

Range("a10") is named TEST

How can I extract the name given the range a10 using VBA?

Thanks in advance.

 

[Tom Ogilvy]

worksheets("Sheet1").Range("A10").Name.Name

It test has a refersto string like

=Sheet1!$A$10

 

[Guest]

I was able to find the answer using trial and error

To get the name for a range you must use the .name.name
extension for a range.

For example Range("a10") is named Test

To extract the name from a10 simply use Range("a10").Name.Name