var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Range Names - creating a list of
Is there any way to create a list of Range names? I created a bunch of names, and now I really need to view all of the names and the referenced cells so that I can use them in code.
Howdy. The best thing to do is download the FREE add-in NameManager. It allows you to do that (and much, much more). I use it everyday (as part of the paid version of FastExcel add-in).
Use the Insert Name Menu: 'Insert->Name->Paste...'
Originally Posted by Krista327
This opens a dialog to paste a single name or list of all names. 'Insert->Names->Define...' allows you to view the list in a dialog window and change, delete, or redifine them.
An alternative with VBA code. This lists up all ranges.
For Each varName In ActiveWorkbook.Names
Debug.Print varName.Name & varName.RefersTo
Great! Thanks for your help!