How can I replace the text string "Reviewer" with "Approver" in all range names of a workbook?
For example, the range name "rFirstReviewerLastName" would be changed to "rFirstApproverLastName"
Something like the code below --which I got from a prior post-- (except that I made up the CONTAINS function).
For Each nm In ThisWorkbook.Names
If CONTAINS("Reviewer",nm.Name) Then nm.Name = Replace(nm.Name, "Reviewer", "Approver")