Excel Shortcuts List for Mac and PC (Searchable) How to Use this Shortcut List. Named Range Shortcuts. You will also be able to create Custom Practice Sets and receive access to our newsletter with additional Excel / VBA tutorials and tips.

I'm cleaning up a bloated Excel workbook and am trying to bulk delete named ranges that are referring to workbooks on someones 'C' drive. Mouse driver for windows 10. There are a lot of them. And they are not being used in this Workbook. 'C: blahblah. [WorkBookName.xls]Sheet1'!$E$28 The code below helped me delete named ranges where their name contains 'icon' (for example).

However, I really need to delete the range when it contains a path as shown above. Bearing in mind that the Workbook or Sheet name could also change, but the drive remains the same. Sub deleteNamedRangesSpecific() For Each NR In ActiveWorkbook.Names If NR.NameLocal Like '*' & 'icon' & '*' Then NR.delete Next End Sub Any ideas how to delete according to the range itself, not the name of the range?