Getting named range from a cell

[Guest]

If cell A1 has a named range of "Cell.Testname" what code can I use to put
this name into a VBA variable. I can only pull through the actual cell
co-ordinates and it is frustrating the hell out of me!!!!

 

[Norman Jones]

Hi Dandog,

Try:

Var = Range("A1").Name.Name

 

[Guest]

Why is it the simple ones that can trip us up!!

Perfect outcome with this - thanks