1.

=REPLACE(CELL("Address",(A1,List)),1,5,"")

where List is the named range of interest. The way the CELL() function
behaves here is first reported by Harlan Grove.

2.

=CELL("Address",List)&":"&CELL("Address",INDEX(Lis t,MATCH(2,1/(1-ISBLANK(List)))))

which must be confirmed with control+shift+enter instead of just with
enter.

Obviously, [1] is more efficient/fast and also correct for the last
cell of List might be empty by intention.

pcress Wrote:
Is there any worksheet function that returns the address (text) of a
named
range? I have used the paste list menu option but require a worksheet
function to return the address


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=277943