View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default how do I paste range name list?

For Each nme In Activeworkbook.Names
Debug.Print nme.Name
Next nme

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Adesso" wrote in message
...
Part of my homework assignment is to paste a list of all existing named
ranges. How do I do that?