I have a spreadsheet that for various reasons I would like to un-name about 400 named ranges. For instance, in the Name Manager, I have a value of 3.5 that is assigned to "Slk_B" and a range of $A$1:$A$5 assigned to "Plot_bb"
I need to undo all those named ranges to simply be back to their absolute ranges. Is there a way to do this? I've been doing it by hand with some find and replace.
Thanks,
Matt
Bookmarks