When you’re copying spreadsheets around all over the place (particularly if you use the excellent advanced copy trick for isolating unique cells), you build up a gigantic store of named range. These are infurating.
Well, luckily I’ve developed a little VBA sub that wipes them all out:
nameCount = ActiveWorkbook.Names.count
counter = nameCount
Do While counter > 0
counter = counter - 1
This made my friggen day.