I am pretty sure this is a simple question that I am far to simple to
be able to find the answer to, but does anybody know how to return the
cells that a named range refers to?

by this I mean the formula that you see when you go to the insert
name define menu including any offset formula used in defining the
range.

I want to do this using vba but so far have only been able to return
what the range refers to with the path and filename attached, if it is
possible to return it without these so I dont have to cut bits out of
the string then I would be much abliged if someone could tell me how
or point me in the right direction.

Cheers,

Tim