What it does
Shows an auto-complete search form that can be used to find and jump to a named range. 

When to use it
When you have a workbook with many named ranges and you want to search for one of them with suggestions as you type.

Why to use it
This macro shows search suggestions as you type, making it extremely quick to find named ranges with just a couple of keystrokes.

Default shortcut
None

Other Details

• Category: Formulas / Named Ranges
• Difficulty: 2/5
• Usage/frequency: 3/5
• Automation factor: 4/5 (estimated 10 seconds saved each time used)
• Type: Shortcut
• Date added: 11/10/2018
• Tags: search, auto complete, named ranges

Related Macros
Named Range Picker

Other Articles
None

None

Prerequisites
None

Instructions
Run the Search Named Ranges macro.  It will prompt you with a search form offering you suggestions of named ranges in your workbook as you type.  Use the up and down arrows (or click with the mouse) to select a suggested named range and insert the entire range name in the search box.  When the entire range name is in the search box, press the Enter key to jump to it.

Press the Escape key to clear the search box.  If the search box is empty when you press the Escape key, the search box will close.  You can also clear the search box by pressing the X icon to the right of the search box.

There are three icons to the right of the search box that will sort the search results either ascending, descending, or in the order they appear in the named range manager.