Part of my homework assignment is to paste a list of all existing named ranges. How do I do that?
A Adesso Jan 20, 2007 #1 Part of my homework assignment is to paste a list of all existing named ranges. How do I do that?
B Bob Phillips Jan 20, 2007 #2 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)
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)
