Add-In needed to Change Names

[drom]

Hi and Thanks in advance!

One of the Workbooks I am working, is quite old.
I have been working with the workbook, last 5-6 years.
Obviously 5-6 years ago I did not know much about vba, and/or about using names.

so I was applying any name to different ranges.

At present I am refereing to many of these names from vba.

Since the owner of the WorkBook is one of my biggest customers, last 3/4 weeks I have been cleaning the vba code eg: change dim Customer as boolean o dim bCustomer as boolean


I would like to change many of the names "I mean reName those names"
This is easy using a macro.


But is there any add-in to apply those New names to the vba code??

eg if: sheets("Country").range("Spain") is named Spain and in my vba code I refer to this range as:

dim spain as range: set spain=sheets("Country").range("Spain")

I would like to Rename the Name "Spain" to "cSpain" and see on my vba code:
dim spain as range: set spain=sheets("Country").range("cSpain")

Thanks!


doit manually could take me 1day