Renaming NAMED RANGES from a list with VBA, and in Bulk

[novabond]

hello
my workbook has lots of named ranges over lots of worksheets, included in lots of formulas

SET UP - I have created a worksheet within the workbook called ChangeNameRages, whereby:
in column A starting on line 2, I have listed all the CURRENT names, of all the named ranges in the workbook
in column B, I have listed the CHANGE_TO name, that I would like the named range in the adjacent 'current name' column A, to be changed to.

WOULD LOVE VBA CODE -
1) rename all Named Ranges, throughout the workbook, as per my list in worksheet ChangeNameRanges
2) update all formulas, within the workbook, as per my list in worksheet ChangeNameRanges

Yesterday I posted for the same principle but, to change the names of TABLES, this was solved overnight, and the code worked so brilliantly, that I immediately realised, I have even more Named Ranges to change, and why didn't I think of that at the same time... so here I am again...

TIA, looking forward to responses!....

 

[Jimmypop]

Try this previous thread...

VBA Code to Rename a Defined Range

I am trying to find a way to use VBA to change the name of a Defined Range. Everything I have found so far creates a new range and then deletes the old range. I have used the existing named ranges throughout a large workbook, so I don't want to delete the existing named ranges. Also, I have...

www.mrexcel.com