This is as far as I can get today.
If A11 is named ABC then =MYNAME("$A$11") will return ABC

Function myname(rng)
Set nms = ActiveWorkbook.Names
myname = "BLANK"
For r = 1 To nms.Count
If rng = nms(r).RefersToRange.Address Then
myname = nms(r).Name
End If
Next
End Function

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bol" wrote in message
...
Is it possible to show the defined name (from insert/name/define) of
another
cell? For instance: cell B1 is defined as "abc". What do i type in cell A1
to
get this texts text ("abc") from cell B1?

Please help!