Solved: Listing Named Ranges and Ranges

[cleturno]

I have a sheet that was given to me that someone else built. They were very into using named ranges and cells. Is there a way to get a complete list of the named ranges and the range that they refer to and print this list out?? There are over 300 named ranges within this sheet.

Thanks,
Chris

[lenze]

With the file open, select a blank sheet to enter the names on. Enter F3 to see all the names. Choose Paste list

lenze

[cleturno]

Thanks, this is soemthing that I am not familar with and that was definately an easy fix. I would like to thank all of the VBAexpress for there expedient help on any questions that I have posted.

[lucas]

Glad you got your answer....nice one lenze
Mark thread solved under thread tools appears to be working now