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...