Replacing Range Names

[Jim May]

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

 

[Bob Phillips]

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]

Thanks Bob, but I was looking for a VBA solution.
Jim