Hi
for the 'first' cell of your range you could use
=CEL("address",your_range_name)

--
Regards
Frank Kabel
Frankfurt, Germany

"pcress" schrieb im Newsbeitrag
...
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