Pasting Named Range List to a Worksheet
Maybe hitting F3 and clicking Paste List would be sufficient.
But I wouldn't use this. I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It makes working with names much, much easier. Chad wrote: Is there a way to automate the InsertNamesPasteList function in order to keep a running tab of the named ranges in a workbook? Any help would be greatly appreciated, Chad -- Dave Peterson |
All times are GMT +1. The time now is 11:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com