Need a Macro to rename part of all named ranges on a sheet

I need a macro to rename part of all named ranges on only one sheet in a workbook just part of the name text from "S1" to "S2".

Therefor leaving the remainder text of the names intact.

So that "Range_S1" Becomes "Range_S2" e.g. i.e it will change only the names on that sheet with S1 in them and replace with S2

This might work - hard to know without seeing the spreadsheet:

Please Login or Register  to view this content.

Can you use wildcards, I only want to change the S1 to S2 rather than overwriting the whole name.

Try this

Please Login or Register  to view this content.