Hi Dandog,

Try:

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


---
Regards,
Norman



"Dandog" wrote in message
...
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!!!!