go to a blank worksheet
Insert=Name=Paste. . .

select the paste list button.

--
Regards,
Tom Ogilvy

"paul johnson" wrote in message
...
I have a spreadsheet using 100 plus named ranges.
Is there a quick way to document all these ranges?

Many Thanks

Paul