I have a module to export a spreadsheet which has named ranges. There are duplicate names, however I want to keep one and delete the other. I know how to delete all of them, but how do I get a specific one.
Example: Name1 has two different Scopes (workbook and worksheet) and Values(123 and #Ref!). I want to delete the one that has Scope = workbook and Value = #Ref!, when I run the function it deletes both occurences of Name1. How do I specify the exact one that I want to delete?