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

I have managed to solve the problem myself, I had mistakenly moved a
sheet into the workbook and the named ranges associated with it were
all referenced to the originl workbook.

Sorry for taking up anybodies time.

Tim

I assume you are referring to

Range("Name").RefersTo


Possibly you can use

Range("Name").ReferstoRange.Address(0,0)



--
Regards,
Tom Ogilvy


"Tim" wrote in message
oups.com...
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