Usually, if I write a piece of utility code I check online at some point to see if it hasn’t already been done. It’s always good to see other ways of doing something. I try to always write the code myself first as a challenge.
Anyway, yesterday after posting my code about using VBA to list names in Excel I checked and actually found that Excel already has a way to do this built in:-
Click Insert > Name > Paste… and you get this handy little dialog.
Clicking on the ‘Paste List’ button on this form does exactly the same as yesterday’s code, barring making a new worksheet and adding bold and underlined headers!
I guess you do learn something new everyday!