| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing Range Names
I have several .xls files based originally on a template file.
The RangeNames currently assigned in these several files need to be totally-replaced with the current range names in my RevisedTemplateFile.xlt file. How can I accomplish this? TIA, Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing Range Names
Get hold of the latest version of Jan Karel Pieterse's Namemanager, I
believe this versions supports renaming. http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... I have several .xls files based originally on a template file. The RangeNames currently assigned in these several files need to be totally-replaced with the current range names in my RevisedTemplateFile.xlt file. How can I accomplish this? TIA, Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing Range Names
Thanks Bob, but I was looking for a VBA solution.
Jim "Bob Phillips" wrote: Get hold of the latest version of Jan Karel Pieterse's Namemanager, I believe this versions supports renaming. http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jim May" wrote in message ... I have several .xls files based originally on a template file. The RangeNames currently assigned in these several files need to be totally-replaced with the current range names in my RevisedTemplateFile.xlt file. How can I accomplish this? TIA, Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference to range names | Excel Discussion (Misc queries) | |||
| not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
| Range Names | Excel Worksheet Functions | |||
| Excel Range Names | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Linear Mode
