You probably need a VBA function for this. Here's one to get you started. To
use it, you need to put the name in quotes in the formula, i.e.

=NamedRangeAddress("MyRangeName")

It needs to be made much more robust. Right now it would work only for a
workbook-level name, and it returns something like

=Sheet1!$A$1:$A$10

Function NamedRangeAddress(sName As String) As String
On Error Resume Next
NamedRangeAddress = ThisWorkbook.Names(sName).RefersTo
End Function




On Fri, 12 Nov 2004 19:38:01 -0800, 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