Names in Workbook

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

I've named a bunch of cells in my workbook and would like
to be able to print off all the names. I would also like
to take all the names and put them into a sheet in my
workbook in order to write a description to remind myself
and others what each name refers to. Is this possible?

I would also like to do the same thing with the names for
all my macros. Thanks.
 
I've named a bunch of cells in my workbook and would like
to be able to print off all the names. I would also like
to take all the names and put them into a sheet in my
workbook in order to write a description to remind myself
and others what each name refers to. Is this possible?
Click to expand...

Select the upper left cell of the range into which you want to put the list of
range names, then run the menu command Insert > Names > Paste..., and click on
the Paste List button in the Paste Name dialog.
I would also like to do the same thing with the names for
all my macros. Thanks.
Click to expand...

Much, much harder. Doing this would require macros that read through other VBA
modules. It'd be expedient to do this manually, copying entire VBA modules,
pasting into worksheet ranges, then deleting all rows except those containing
the top line of each procedure, i.e., the ones beginning with Sub or Function.
 
Back
Top