In a workbook, I have a macro that I use to create a number (50-100+) named ranges. However, the names of these ranges will change somewhat frequently and I am trying to avoid having unused named ranges going forward as the macro is run additional times. What I am looking for is a method to delete all of the named ranges in a workbook that do not have a comment (or are simply not ones generated by the first macro) since I have some other named ranges that will not change that I have comments written for. Is this possible with VBA or is there another method that I can use to prune these unused ranges?