View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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