Name Ranges

[Charlie Woll]

I have a workbook with a number of named ranges. I would like to list and
print the names and the assigned ranges. Is there a good way of doing this?

--

 

[Kevin Stecyk]

Charlie Woll wrote

I have a workbook with a number of named ranges. I would like to list and
print the names and the assigned ranges. Is there a good way of doing

this?

Yes, get a name manager from Jan Karel Pieterse's site here:

http://www.jkp-ads.com/Download.htm

It has the ability to display all the range names.

Best regards,
Kevin

 

[JE McGimpsey]

One way:

Try Jan Karel Pieterse and Charles Williams's Name Manager add-in, which
you can find at:

http://www.bmsltd.ie/MVP

I've also written some code with a different output:

http://www.mcgimpsey.com/excel/listnames.html

 

[Dave Hawley]

Hi Charlie

On a clean Worksheet, select A1 and go to Insert>Name>Paste

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Charlie Woll]

Thank you Dave, This is exactly what I was looking for.
charlie