Thread: [Solved] Using Defined Names
View Single Post
 
Old 10-12-2015, 02:45 PM
shg shg is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default

You can just type the whole name in, right?

I reckon you could write a macro that lists all the names in a listbox or combobox, and code it to do autocomplete on that, but it seems like a lot of effort for not much gain.

I expect it doesn't auto-complete because you can also use the Names box to add a named range to the worksheet or workbook.
Reply With Quote