Named Range Refers To
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 |
Named Range Refers To
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 |
Named Range Refers To
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 |
All times are GMT +1. The time now is 05:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com