Excel Tricks - Part 4 : GetNames - Getting a list of named ranges

Welcome to RPM IT Consulting's Excel hints and tips blog - over the next few months we will be adding to our Excel Tricks blog with some useful hints and tips.  Some you will know. some you wont, some you may have forgotten, some may be useful and some will be for  fun!    GetNames This VBA code can be used to find and list all the named ranges/cells and their names in a workbook. The named ranges are then displayed to the user in a new sheet. ‘This does this by inserting a new sheet and then